WP-DBManager
Add to ListFeatures
- Backup Database
- Manage Database
- Optimize Database
- Repair Database
- Empty/Drop Tables
Support
You will get excellent support for this plugin from developer Lester Chan, 9 out of 9 support threads have been resolved in the last two months. There is no documentation for this plugin although there is a support forum available on their website.Plugin ver- 2.7.0
WordPress ver- 3.9.1
Tested on 11 May, 2014
System configuration: 1 core processsor, Memory - 512mb, 20gb SSD Disk
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
- Activate
WP-DBManagerPlugin - The script will automatically create a folder called
backup-dbin 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 - Go to
WP-Admin -> Database -> DB Optionsto configure the database options - Secure the backup folder, see below
- Go to
WP-Admin -> Database -> Backup DB, which checks whether the folder is actually reachable over HTTP and tells you if it is
Securing The Backup Folder
A database backup contains everything, including your users table. Anyone who can guess a backup file name can download the lot, so the folder must not be served over HTTP.
The reliable option, on any server: set Path To Backup under WP-Admin -> Database -> DB Options to a folder outside your web root, for example /var/www/example.com/backup-db when WordPress lives in /var/www/example.com/public_html. Nothing served, nothing to configure.
If the folder has to stay inside the web root:
- Apache — move
htaccess.txtfromFolder: wp-content/plugins/wp-dbmanagertoFolder: wp-content/backup-db/.htaccess - IIS — move
Web.config.txtfromFolder: wp-content/plugins/wp-dbmanagertoFolder: wp-content/backup-db/Web.config - nginx — nginx does not read
.htaccessfiles, so the file above does nothing. Add this to your server block and reload nginx:
location ^~ /wp-content/backup-db/ { deny all; }
Move index.php from Folder: wp-content/plugins/wp-dbmanager to Folder: wp-content/backup-db/index.php as well, so the folder cannot be listed.
The Backup DB page requests a file from the folder and reports what the server actually returns, so you can confirm the folder is closed rather than assume it.
Development
Credits
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.