backup

#!/bin/bash

DATE=$(date +"%m-%d-%Y")
DATABASES=`mysql -e "SHOW DATABASES" | tr -d "| " | grep -Ev 'Database|information_schema|performance_schema|mysql'`

echo "Dumping Databases"

for db in $DATABASES
do
        echo "========================"
        echo "Dumping $db"
        mysqldump --add-drop-table $db > /var/backups/$DATE-$db.sql
        echo "========================"
done

echo "Done Dumping Databases"

echo "======================="

echo "Transferring Databases"

rsync -rltgoD --progress /var/backups/ [email protected]:/storage/noppix/lemp2/mysql/

echo "======================"

echo "Removing Databases"
rm -rf /var/backups/*.sql