backup_mysql.sh

#!/bin/sh

backupdir=/data/archive/mysql-backups
pwd=`pwd`
today=`date "+%Y-%m-%d"`

cd $backupdir
rm -f latest
rm -rf $today
mkdir $today
ln -s $today latest
cd $today

for db in `mysql -e 'show databases' | egrep -v 'Database' `; do
    echo "Dumping $db"
    rm -f $db.sql
    mysqldump --opt --add-drop-database --lock-all-tables -hlocalhost -uroot --databases $db > $db.sql
    tar czf $db.tar.gz $db.sql
    rm -f $db.sql
done

cd $pwd