WP-DBManager

Allows you to optimize database, repair database, backup database, restore database, delete backup database , drop/empty tables and run selected queries. Supports automatic scheduling of backing up, optimizing and repairing of database.

General Usage

1. Activate WP-DBManager Plugin
2. The script will automatically create a folder called backup-db in the wp-content folder if that folder is writable. If it is not created, please create the folder and ensure that the folder is writable
3. Open Folder: wp-content/backup-db
4. If you are on Apache, move the htaccess.txt file from Folder: wp-content/plugins/wp-dbmanager to Folder: wp-content/backup-db/.htaccess if it is not there already
5. If you are on IIS, move the Web.config.txt file from Folder: wp-content/plugins/wp-dbmanager to Folder: wp-content/backup-db/Web.config if it is not there already
6. Move index.php file from Folder: wp-content/plugins/wp-dbmanager to Folder: wp-content/backup-db/index.php if it is not there already
7. Go to WP-Admin -> Database -> DB Options to configure the database options

Build Status

Development

• https://github.com/lesterchan/wp-dbmanager

Translations

• http://dev.wp-plugins.org/browser/wp-dbmanager/i18n/

Credits

• Plugin icon by Freepik from Flaticon

Donations

• I spent most of my free time creating, updating, maintaining and supporting these plugins, if you really love my plugins and could spare me a couple of bucks, I will really appreciate it. If not feel free to use it without any obligations.

Disclaimer

• Note that this plugin passes your datababase password via –password in the command line of mysqldump. This is convenient but as a trade off, it is insecure.
• On some systems, your password becomes visible to system status programs such as ps that may be invoked by other users to display command lines. MySQL clients typically overwrite the command-line password argument with zeros during their initialization sequence. However, there is still a brief interval during which the value is visible. Also, on some systems this overwriting strategy is ineffective and the password remains visible to ps. Source: End-User Guidelines for Password Security
• If this is a concern to you, I recommend another database backup plugin called WP-DB-Backup
• To know about the difference between WP-DBManager and WP-DB-backup, checkout What is the difference between WP-DBManager and WP-DB-Backup? in the FAQ section.