This Linux shell script has been a life saver on many occasions. It automates the process of backing-up and rotating your MySQL backups using mysqldump. It creates separate backup files on a daily, weekly and monthly basis. It also provides email logs in the event of an error.
Download the script here: http://sourceforge.net/projects/automysqlbackup/develop/