#!/bin/bash

USER="<mysql username>"
PASSWORD="<mysql pass>"
OUTPUTDIR="<output for files>"
MYSQLDUMP="/usr/bin/mysqldump"
MYSQL="/usr/bin/mysql"
RSYNC="/usr/bin/rsync"

# clean up any old backups - save space
rm $OUTPUTDIR/* > /dev/null 2>&1

# get a list of databases
databases=`$MYSQL --user=$USER --password=$PASSWORD -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`

# dump each database in turn
for db in $databases; do
    $MYSQLDUMP --force --opt --user=$USER --password=$PASSWORD --databases $db > "$OUTPUTDIR/$db.bak"
    gzip $OUTPUTDIR/$db.bak
done

# make a file containing backup time

date > $OUTPUTDIR/date

rsync -e 'ssh -p 22' -az $OUTPUTDIR/* <user@ip>:/backup/mysql