I recommend you this script which names "automysqlbackup".
Look it at Google with two words: "automysqlbackup" and "sourceforge"
Since I have not posted on this forum, by now, more that 5 times, the forum program does let me publish full URL here :-(
A script to take daily, weekly and monthly backups of your MySQL databases using mysqldump. Features - Backup mutiple databases - Single backup file or to a seperate file for each DB - Compress backup files - Backup remote servers - E-mail logs - More..
I use for two years and had never probelm and what is good that you get mail reports and saves daily/weekly/monthly backups. It happened once when one table was corrupted and MySQL could not perform backup, instead of 50 Mb file it was only ~15Kb. I saw it immediatelly and fixed the same day!
It was good because just few weeks later I was hacked and could restore to most latest condition just in minutes.