If you're self-hosted and run a WordPress blog, there's absolutely no excuse for not having a current backup of your WordPress database.

WordPress Database Backup, now at version 2.1.2, is currently being maintained and is kept up-to-date by Austin Matzko at Il Filosofo. I recommend this plugin for creating your primary backup daily. You can have it emailed to you instead of saving it on the server.

A second backup option is Lester "GaMerZ" Chan's WP-DBManager. The latest version (2.11) incorporates everything the other one has in it and much more. Due to shared hosting, some people (like me) have problems with certain functions that are used. It's a simple matter to change the word 'passthru' to 'exec' in those places, if that's the only problem you have. These are the files I had to change:

  • database backup.php - line 53
  • database-manage.php - line 53
  • dbmanager.php - line 78

Other than that, everything else worked like a charm. I have both plugins sending me backups by email daily, which I discard once they become more than a week old, but I use the scheduled maintenance functions of the latter.

So you see, with two automatic backup options (the only two that I know of), there really is no excuse not to have a backup.

Update:

Hari reminded me that some hosts offer automated backups on their servers as well.

Matthew reminded me about his post on using cPanel (if your host uses it) to back up the entire website, not just the database.