Backing Up the WordPress Database
How to backup your WordPress Database:
Backing up your WordPress database on a regular basis is very important. By very important I mean it’s right up there with oxygen. If you don’t have either you are screwed.
There are a multitude of ways to backup your databases. If you use CPanel you can do it there. The easiest way I’ve found so far however is the WordPress Database Backup. The name says it all really.
Install and activate this plugin. On your left column menu go to Tools -> Backup and there it is.
You can select specifically which of your WordPress databases to backup and which to exclude. You can generate a backup file on demand and store it on your server, download it, or send it via email.
You can also schedule backups and have those stored on your server or emailed to an address. This is the greatest thing ever for automated and secure backups.
The current version of this plugin is 2.2.3 and I suggest this should be the first plugin you add to any WordPress installation.