One thing that has been bugging me since moving my blog to GoDaddy for hosting, is the PITA that MySQL backups have become. Back when I was on the Learning Commons’ webserver, I could just create a crontask to dump the MySQL tables every morning. No SSH or shell access to my GoDaddy account means using a web interface to backup, which is less than automatable.
WordPress to the rescue! There’s a WordPress Database Backup Plugin that can easily download or email database backups to you, and when tied with WP-Cron (a cron-like plugin for automating stuff), it’s fully automatable! I now have daily database backups gzipped and emailed to my GMail account for safe keeping.
I heart WordPress…
One thing that has been bugging me since moving my blog to GoDaddy for hosting, is the PITA that MySQL backups have become. Back when I was on the Learning Commons’ webserver, I could just create a crontask to dump the MySQL tables every morning. No SSH or shell access to my GoDaddy account means using a web interface to backup, which is less than automatable.
WordPress to the rescue! There’s a WordPress Database Backup Plugin that can easily download or email database backups to you, and when tied with WP-Cron (a cron-like plugin for automating stuff), it’s fully automatable! I now have daily database backups gzipped and emailed to my GMail account for safe keeping.
I heart WordPress…
Boy, was Alan right… Don’t use the version of MySQL (4.0.16) that comes prepackaged in MacOSX 10.3 Server. Man, does it stink.
Update to 4.0.17, using the handy dandy installer provided on MySQL.com/downloads – it works great, and even starts on boot (unlike the version that comes with panther…) Just bit the bullet and updated versions on careo.ucalgary.ca, and the weird database behaviour has apparently disappeared.
Boy, was Alan right… Don’t use the version of MySQL (4.0.16) that comes prepackaged in MacOSX 10.3 Server. Man, does it stink.
Update to 4.0.17, using the handy dandy installer provided on MySQL.com/downloads – it works great, and even starts on boot (unlike the version that comes with panther…) Just bit the bullet and updated versions on careo.ucalgary.ca, and the weird database behaviour has apparently disappeared.