Since I am maintaining several WordPress installation now, I feel that it is quite a tiring chore to backup the databases every now and then. I used to do it once a week, and it is even a recurring event in my pocket PC. It was WordPress Database backup 0.8 and every time I clicked on the link on the plugin page, the site is no longer there. I thought Skippy was doing maintenance and because of other commitments I let the thought go.
A few days ago, I was thinking of writing an automated plugin, and I searched for it first not to reinvent the wheel. I found it at a different site: http://www.ilfilosofo.com/blog/wp-db-backup, and learned that the plugin has changed hands from Skippy (Scott Merrill) to Austin Matzko.
I was excited to learn that the new plugin support the cron hook provided by WordPress 2.1. Yay! And the plugin worked flawlessly:
One thing you might want to take note is that the cron event is not a real, system cron event but it is triggered when your site is accessed. I noticed that when I installed and configured the email function on a newly set up installation (hence no traffic) it didn’t work until I access the site.
The plugin can also be configured to save the backup files to the server, but of course this is not recommended because of security reasons.
Have a try, I believe you’ll love it. However do remember to also backup your image files separately!