ShoutMeLoud – Shouters Who Inspire

Superlinks
≡ Menu
≡ Menu

How To Use WP-DBManager WordPress Database Plugin

CW
How To Use WP-DBManager WordPress Database Plugin

Recently I have talked about WP optimize plugin and how you can reduce the database size of your blog. I have mentioned about WP-DB manager plugin many times and I realize it’s 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 which a WordPress blogger will need in time to time. This plugin offers database backup (You can schedule backup too), but I’m more interested in other features and I will be talking about them in this post. Let me start with the features of this plugin.

How to use wp dbmanager

Features of WP-DB Manager plugin:

As name suggested, this is a WordPress database plugin which makes it easier for you to access your database from WordPress dashboard. The best part is, the user interface is designed for non-technical users who can quickly get things done without getting overwhelmed with the plenty of options. This plugin offers 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 to Install and activate this plugin right now. Here is the download link from WordPress plugin repo. Once plugin is activated, you can access the settings and start using this plugin from left panel of your WordPress dashboard. Here are features:

  • Database: Here you can see the details about your database and tables name with the index usage. What good here is, you can quickly find out which table is using tons of records. After using this feature I realised that redirection plugin 404 error log feature was making my database bulky. Similarly you can find out which one of your plugin is adding too many records in your WordPress database.
  • Backup DB: This feature will let you take a backup of your blog database. You can either gZip or take backup without compression. I recommend to use gZip when your database size is big.
  • Manage Backup DB: Here you can see the total number of backed up database and download it. Similarly you can also use this feature to restore your blog from an existing database. Just to give you an idea, your backup is incomplete without the WP-content folder (You can download it via FTP).
  • Optimize DB: This feature will let you optimise the database of your blog. You also have the control to select or deselect any table which you don’t want to optimise.
  • Repair DB: Many times you will notice your blog homepage is showing no posts & it happens due to corrupt database ( In majority of the cases). Using this functionality you can quickly repair your database. In last 5 years I have used this feature at least 8 times. Something you should know as you may need this feature any day.
  • Empty Drop tables: Using this you can empty the records of any table or simply remove the table from your database. I suggest to use 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 let you run the query right from your WordPress dashboard. I have mentioned few queries in my earlier post on reduce WordPress database size, which will be a good place for you to get started. If you just need to get access to phpmyadmin in WordPress dashboard, You should also look at Adminer plugin which is free and stand-alone.
  • DB Options: Here you can configure your backup options including path where you want to take back up of your database. You can also configure how often your blog database should be backed up, optimised and repaired automatically. I suggest you to don’t use optimise and repair feature, as it’s good if you manually do it once in a month.

WordPress Database plugin

How to use DB Manage WordPress plugin?

In the above features I have already mentioned how and when to use specific features and for now you can start with taking a backup of your database and optimising your database. You can also configure this plugin to take automatic backup of your database, but I would recommend some other plugin which can take database backup along with your WP-content folder. (You can’t restore a blog on a new server just with database backup).

Note: When you will install this plugin you will be seeing a notice at the top of your backend dashboard: “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). 

Here is a video guide for using WP-Db manager plugin and I have also highlighted few best practices for your database in this video.

You can browse more videos related to Blogging and WordPress on my Youtube Channel here. To end with, WP-Db manager plugin is one of the best multi-purpose database plugin for your WordPress blog. Even if you don’t need it now, you should know about it as this will be handy in the time of crisis. If you want me to review any other plugin, you can let me know via comments.

  • Author Bio

  • Latest Post

Article by Harsh Agrawal

Harsh has written 1069 articles.

If you like This post, you can follow ShoutMeLoud on Twitter. Subscribe to ShoutMeLoud feed via RSS or EMAIL to receive instant updates.


{ 7 comments… add one }

  • Bnimbhal

    Hi,

    Their is an another plugin to delete unused dbtables, as I am not a developer so its difficult for me to find the unused tables.

    plz review https://wordpress.org/plugins/wpdbspringclean/

    Thanks

    Reply
    • Harsh Agrawal

      Thanks for adding another resource but the plugin has not been updated for long. I won’t recommend this to all.

      Reply
  • Mukul Bansal

    Harsh Getting this error when I installed this plugin
    Can you help me resolve this

    Checking MYSQL Dump Path …
    MYSQL dump path does NOT exist. Please check your mysqldump path under DB Options. If uncertain, contact your server administrator.

    Checking MYSQL Path …
    MYSQL path does NOT exist. Please check your mysql path under DB Options. If uncertain, contact your server administrator.

    Checking PHP Functions (passthru(), system() and exec()) …
    passthru() disabled.
    system() disabled.
    exec() disabled.

    I’m sorry, your server administrator has disabled passthru(), system() and exec(), thus you cannot use this backup script. You may consider using the default WordPress database backup script instead.

    Reply
    • Harsh Agrawal

      @Mukul
      You need to contact your hosting support team to get it enabled!

      Reply
  • jessica

    I find this plugin useful, however, I have difficulty in uninstalling this plugin. Recently, I installed this to one of my blogs but I encountered a problem after moving .htaccess to backup folder. When I go to my blog and refresh, it says the backup DB folder does not exist” where infact it exists. So I decided to uninstall it using the tab in wp manager setting, unfortunately , it deleted all my post..That is so miserable.

    Can you please provide a tutorial how to uninstall?..I need this since I am a newbie to wordpress..

    Reply
    • Harsh Agrawal

      @Jessica
      You just need to deactivate the plugin and delete it from plugins folder.

      Reply
  • George Serradinho

    Hey, i have this plugin installed on my blog for sometime now. I love it and it’s easy to use. I like the way you can schedule backups and get it emailed to you and the optimizing feature.

    I think this plugin is a must for all sites using WordPress. I don’t know what I would do if I never had this plugin.

    Reply

Leave a Comment