[cpace32]

Look into using mysqldump, via cron. It should look something like this:

mysqldump -u root --password='your_password' --all-databases >/path/to/backups/mysql-`echo $DAY`.sql

This will backup your databases daily, saved by the day of the month.