MySQL Backup Script

backup.sh

#!/bin/bash
########################
######## CONFIG ########
########################
databases=("database1" "database2" "database3")
mysql_host="localhost"
mysql_user="asdf"
mysql_password="pass"
storage_dir="/backups"
name="mysql"
##################
d=$(date +%F_%H.%M)
dir=`mktemp -d`
extrasFile=`mktemp`
trap "rm -rf $dir $extrasFile" EXIT
echo "Dir $dir ExtrasFile $extrasFile"
# pass password safely to mysqldump
chmod 600 $extrasFile
echo '[client]' >> $extrasFile
echo "password=$mysql_password" >> $extrasFile
for db in "${databases[@]}"; do
        mysqldump --defaults-extra-file=$extrasFile $db -h$mysql_host -u$mysql_user --single-transaction | gzip > $dir/$db.sql.gz
        echo $db
done
tar -C $dir -cvf $storage_dir/${name}-$d.tar .
# delete backups older than 30 days
find $dir -maxdepth 1 -mtime +30 -exec rm {} \;