goSammy is the blog of Sam Lu, a web developer/college student with interests in programming and design. If you'd like to keep up with my blog, feel free to subscribe via RSS or email.
In part one of this tutorial, Automating Your Server Backups On Media Temple’s Grid-Server, I explained how to automate backups of your files on your grid-server. Unfortunately, not all your data was covered in those backups because it did not include your database. Now I will describe how you can utilize cron and mysqldump to automate database backups on the grid-server side.
Since running this blog on Media Temple’s grid-server, I was spoiled by the minimal effort required to backup my web stuff online thanks to the Data Backup utility available through the grid-server admin panel. Unfortunately, this utility was pulled over a month ago and I always want a backup to revert to in case an upgrade of WordPress or some other installation goes wrong. In this post I outline how to automate backups using rsync and cron.
