tarsnap database backup cron script

gistfile1.txt

#!/bin/bash
# This script backups every MySQL database to its own file
#Some variables you can set how you like

USER='root'
PASSWORD='X'
OUTPUTDIR='/home/backup/butterfly-sql'
MYSQLDUMP="$(which mysqldump)"
MYSQL="$(which mysql)"
TARSNAP="$(which tarsnap)"

#Clean up any old backups

rm -f $OUTPUTDIR/*

#Get a list of databases names except the system one

databases=`$MYSQL --user=$USER --password=$PASSWORD -e 'SHOW DATABASES;' | grep -Ev '(Database|information_schema|mysql|cphulkd|eximstats|horde|leechprotect|logaholicDB|performance_schema|roundcube|whmxfer)'`

#Dump each database in turn and compress the output
for db in $databases; do

$MYSQLDUMP --opt --force --user=$USER --password=$PASSWORD $db  > $OUTPUTDIR/$db"_"`date +%Y-%m-%d`.sql


done

$TARSNAP -c -f butterfly-mysql_`date +%F_%H-%M-%S` $OUTPUTDIR
#rm -f $OUTPUTDIR/*