Having just paid $125 to get a MySQL database recovered I thought it would be timely to figure out a way to make a backup system for my MySQL database(s) on the MediaTemple Grid Service.
Here is how I do it!
The first step is to backup the database(s) to the file system.
Just go to http://sourceforge.net/projects/automysqlbackup/, download the script, modify it and upload it to your server.
I use “Cron Jobs” in the Media Temple Control Panel to run the automysqlbackup script daily. The script conveniently handles daily, weekly, monthly folders plus rotation.
Next, I make sure my entire home folder (including the dbbackups) get copied to another server using rsync.
I really like this way of doing it because I think it’s important to have different snapshots of the data from different time periods (daily, weekly, monthly). This way I will be able to restore things deleted weeks ago.
Please let me know if you have questions!
Martin Bay | Martin Bay .NET