Back up all MySQL databases - one file per database

mysql-backup.sh

#!/bin/sh

Host=localhost
BDir=~/backup/mysql

read -p "User: " user
read -s -p "Pass: " pass

Dump="/usr/local/bin/mysqldump --skip-extended-insert --force"
MySQL=/usr/local/bin/mysql

Today=$(date "+%a")

# Get a list of all databases
Databases=$(echo "SHOW DATABASES" | $MySQL -h $Host -u $user -p$pass)

for db in $Databases; do
    date=`date`
    file="$BDir/$Host-$db-$Today.sql.gz"
    echo "Backing up '$db' from '$Host' on '$date' to: "
    echo "   $file"
    $Dump -u $user -p$pass -h $Host $db | gzip > $file
done