mysql_backup.sh

#!/bin/sh

today=`date +%Y_%m_%d`
backdir=$HOME/mysql/$today

mkdir -p $backdir

for i in `echo "show databases" | mysql -uUser -pPassword | sed 1d`; do
  mysqldump -uUser -pPassword $i | gzip > $backdir/$i.sql.gz;
done;

find $backdir/.. -mtime +30 -exec rm -rf {} \;
find $backdir/.. -type d -empty -exec rm -rf {} \;

exit 0