WordPress Theme Gallery

Ok, so there are several decent Wordpress plugins for backing up the database, but most of the default plugins for this either do not include plugin database tables and/or do not allow setting up automatic database backups.

WP-Database Manager is a full featured Wordpress database management plugin. This plugin allows you to select which database tables to include in your backups. You can even drop or empty and restore individual tables. This is a great tool for backing up your entire Wordpress database.

Once you have installed WP-Database Manager there will be a new tab called ‘Database‘. You probably won’t need to mess with the settings under ‘Database’ unless you’re getting error messages. It’s a good idea to check this tab to be sure that it displays your database information correctly.

‘Backup DB‘ lets you make a manual backup to the server. To allow this you must be sure that the ‘../wp-content/backup-db/’ directory is writable. These backups are stored and displayed in the ‘Manage Backup DB‘ page.

To configure automatic backups of your database go to the ‘DB Options‘ tab. Scroll down to ‘Automatic Scheduling’ and make your selections. Enter the email address to which these regular backups should be sent.

In restoring database tables you can use either PhpMyAdmin or the WP-DB-Manager interface to upload your backups. This is a very useful plugin for protecting your WP data and one of the best database plugins for Wordpress that I’ve used.