MySQL Dumps

dump-mysql.hourly.sh

#Change lines 6 & 10 to where you want to store your backups

echo 'show databases;'|/usr/bin/mysql --skip-column-names|while read -r db
do
  fn=`date +%Y%m%d%H%S`
  nice /usr/bin/mysqldump $db| bzip2 -9 > /root/backups/mysql/hourly/$fn.$db.sql.bz2
done

#Change +3 to however many days you want to keep backups
find /root/backups/mysql/hourly/ -ctime +3 -exec rm "{}" \;