What's the simplest way to backup my Wordpress database?

Question

I have Wordpress installed on my server for my blog. I back up all the files from the server on a schedule. But this is just the files--not the database. Ideally, I'd like to automatically save a database dump on the server periodically so that it gets backed up along with all the files. What's the simplest way to do this?

Answer 1

There is a plugin called WP-DB-Backup http://wordpress.org/extend/plugins/wp-db-backup/

You can configure it to email you a backup of your blog at a specific interval.

Answer 2

There is also a service, Backupify, www.backupify.com that provides backup services for wordpress.

Answer 3

There are several back-up plugins. The simplest procedure is for the back-up to include the xml export file as then it can easily be imported into another WordPress installation.

One plug-in that does this is BackWPup (http://wordpress.org/extend/plugins/backwpup/). You can set it to email you a back-up at regular intervals. It is highly customizable.

Plug-ins that return only the SQL file are more difficult to restore as you have to go via phpMyadmin rather than simply through a WP backend.