SSH:MySQL Backup

mysql-backup-dbs.sh

#!/bin/bash
# This script backups every MySQL database to its own file

#Some variables you can set how you like
USER='username'
PASSWORD='password'
OUTPUTDIR='/var/backup'
MYSQLDUMP='/usr/bin/mysqldump'
MYSQL='/usr/bin/mysql'

#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)'`

#Dump each database in turn and compress the output
for db in $databases; do
echo Backing up $db
$MYSQLDUMP --opt --hex-blob --force --user=$USER --password=$PASSWORD $db | gzip > $OUTPUTDIR/$db.gz
chown user-backup $OUTPUTDIR/$db.gz
done