Many blogging and content management systems (CMS) provide easy tools for backing up your data. What these tools lack, however, is an automated system that ensures your databases are backed up routinely without any intervention on your part. Why would you need automated backups? To put it plainly, you are a busy person and might have numerous other things on your mind. If there is a way you can remove the burden of having to backup your database manually, you should seize the opportunity. AutoMySQLBackup is one way to get it done.
AutoMySQLBackup is a shell script for Unix and Linux operating systems, so you will need some command line access in order to run it. That means most likely, you will need a VPS or dedicated server. Alternatively, if you run a Unix-like operating system (which includes Mac OS X) at your home or office, you can run this backup script remotely. For Windows you will need another solution.
What it Does
This script serves as an incremental database backup system. It will dump the contents of your database to an SQL file and compress it according to your specifications and on the days and times you choose. It can backup daily, weekly, monthly or all of those times and keep snapshots of previous backups. It can also encrypt your backups and send you notifications when backups complete or fail.
Where Do Backups Go?
AutoMySQLBackup can be configured to save your backups to the drive of your choice, but it also works well with rsync for offsite backup. Best of all, you can easily setup a cron job for it so that it will run at the intervals you specify. If your server has a cron.daily directory, it will work nicely there.
Where to Get It
AutoMySQLBackup is free and open source software licensed under the GNU GPL v2. You can download it for free at Sourceforge.