Usage

Click the Tools or Manage menu in your WordPress admin area.

Click the Backup sub-menu.

The plugin will look for other tables in the same database. You may elect to include other tables in the backup.
** NOTE **
Including other tables in your backup may substantially increase the size of the backup file!
This may prevent you from emailing the backup file because it’s too big.

Select how you’d like the backup to be delivered:

* Download to your computer : this will send the backup file to your browser to be downloaded
* Email : this will email the backup file to the address you specify

Click “Backup!” and your database backup will be delivered to you.

The filename of the backup file will be of the form
DB_prefix_date.sql
DB = the name of your WordPress database, as defined in wp-config.php
prefix = the table prefix for this WordPress blog, as defined in wp-config.php
date = CCYYmmdd_B format: 20050711_039
the “B” is the internet “Swatch” time.
See the PHP date() function for details.

When having the database backup emailed or sent to your browser for immediate download, the backup file will be deleted from the server when the transfer is finished.

Advanced

If you are using WordPress version 2.1 or newer, you can schedule automated backups to be sent to the email address
of your choice.

Do what it says: un-comment MOD_EVASIVE_OVERRIDE and set it to true like so:

define('MOD_EVASIVE_OVERRIDE', true);

That will slow down the plugin, and you can slow it even further by increasing the MOD_EVASIVE_DELAY number from 500.

Better yet, put the lines that define the MOD_EVASIVE_OVERRIDE and MOD_EVASIVE_DELAY constants in your wp-config.php file, so your settings don’t get erased when you upgrade the plugin.

What is wp-db-backup.pot for?

This files is used by non-English users to translate the display into their native language. Translators are encouraged to send me translated files, which will be made available to others here:
http://austinmatzko.com/wordpress-plugins/wp-db-backup/i18n/
https://plugins.trac.wordpress.org/browser/wp-db-backup/i18n/

Why are only the core database files backed up by default?

Because it’s a fairly safe bet that the core WordPress files will be successfully backed up. Plugins vary wildly in the amount of data that they store. For instance, it’s not uncommon for some statistics plugins to have tens of megabytes worth of visitor statistics. These are not exactly essential items to restore after a catastrophic failure. Most poeple can reasonably live without this data in their backups.

WP-DB-Backup has always been one of my must-have plugins for years! Not only do I use it on all of my sites, it’s also one of the first things I install on my clients’ sites.

As an Online Business Manager and web designer, I use it to make on-demand backups before and after I make changes to a website. I also use the scheduling feature for automatic backups.

WP-DB-Backup has saved numerous business owners a lot of grief because I had a resent, clean backup of their database. Since I download the site files when I do the db backup it makes it easy to fix the site when something goes wrong.

One of the things I like best about this plugin is that it’s so simple. Not a lot of fluff. It just does the job and does it well.