How To Use WP-DBManager to Improve WordPress Database Performance
in previous post I have talked about WP optimize plugin and how we can reduce the database size of your site. I have mentioned about WP-DB manager plugin many times in our article for the performance optimization, and I thought it’s an important to write a detailed post about this plugin.I like this plugin not because it’s free, I like it because it offers many features in free which a WordPress blogger will need with time to time. This plugin offers database backup too (You can schedule backup, but I am more interested in other features.
Major Features of WP-DB Manager plugin
WP-DBManager is a WordPress database plugin which makes easier to access database from WordPress dashboard. The best part is, the user interface is well designed for non-technical user’s who can pick the things done .This plugin offers the various feature which you will require once in a while. If you want to look at features while I explain it to you, I suggest you Install and activate this plugin right now. download link from WordPress plugin official site in free. Once the plugin is downloaded & activated, you can access the settings and start using this plugin from the left panel of your WordPress dashboard.
WP-DBManager plugin Feature
Database : you can see the details about database and tables name with the index usage. good thing are here is, you can easily find out which table is using tons of records. After using this feature, I noticed that redirection plugin 404 error log feature was making my database bulky. Similarly, you can find out which one of your plugins is adding too many records in your WordPress database.
Backup DB: This feature allow you to take a backup of your blog database. You can either gZip or take backup without compression. I recommend using gZip when your database size is big.
Manage Backup DB : you can see the total number of backed up the database and download it. Similarly, you can use this feature to restore your existing database. Just to give you an idea, your backup is incomplete without the WP-content folder from Cpanel or via Ftp .
Optimize DB : This feature will allow you optimize the database of your blog. You have the control to select or deselect any table which you don’t want to optimize.
Repair DB : Some times you will notice that your blog homepage is showing no posts & it happens due to a corrupt database (in that case) Using this functionality, you can quickly repair your database. In few years, I always use this feature at least 3-4 times.
Empty Drop tables : Using this you can empty the records of any table or simply remove the table from your database. I suggest using this feature with caution else you might end up breaking your blog. This feature is useful when you have to remove the log entries from any existing plugin (Ex: Redirection or 404 plugins) and when you need to remove a plugin table which you have disabled.
Run SQL Query: When you need to run SQL query this feature will allow you to run the query right from your WordPress dashboard. I have mentioned few queries in my earlier post on reducing WordPress database size , which will be a good place for you to get started.
DB Options: you can configure your backup options including path where you want to take backup of your database. You can also configure how your blog database should be backed up, optimized and repaired automatically.
How to use WP-DBManager WordPress plugin?
In the above features I have already explained how to use specific features, for now, you can start with taking a backup of your database and optimizing your database. You can also configure this plugin to take automatic backup of your database .
Note: When you will install WP-DB Manager plugin you will see a notice on of your backend dashboard hearder : “Your backup folder MIGHT be visible to the public, ” and you need to copy the htaccess.txt file from plugins/wp-dbmanager/htaccess.txt to wp-content/backup-db/.htaccess(Do notice that you need to rename the htaccess.txt to .htaccess after moving the file).
WP-DBManager WordPress plugin Info
Name : WP-DBManager
Type : Free
Download : Download WP-DBManager