Simple MySQL Database Backup

First off, this is for those of us with our own servers. Not those of us on shared hosts, because we’re going to need access to the command prompt and MySQL commands, etc. Some shared hosts may allow some of these things, but most don’t.

Matt Wade Writes:

Just a quick note to recommend AutoMySQLBackup for your MySQL backup needs. This little gem does daily, weekly, and monthly backups. It handles all the backup rotations for you. It compresses the files, can backup to remote servers, email you logs, and much more.

Now if you're like me and you're on a shared host, here is an option for you. There is backupDB. I haven't found something better than that thus far. One problem though, you have to have your own cron job to call it so that it's automated.