When I was migrating my blog from Dreamhost to Bluehost, I had faced so many problems while importing database. This is because I have not used the database correctly means I could have used the database optimisation, database repair plugin, but I didn’t. The final result was my database size goes on increasing.
Earlier, I have talked about the WP sweep and WP-Optimize WordPress plugin to make your database size small and how you can split your database file into smaller chunks so that you can import easily. Here I am going to discuss handy WordPress plugin WP-DBManager, you can call this plugin like all in one DB manager. I am using this plugin since long ago. I like all the features which WP-DBManager offers. It’s a free plugin anyone can take advantage of it.
WP-DBManager allows us to optimise WordPress database, repair database, backup database, restore the database, delete any backup, drop/empty tables and run any SQL queries. What else we want, along with this you can also schedule a backup, repair, optimise of your database. Let’s discuss these features
First, install the WP-DBManager WordPress plugin; you will see the database option to your WordPress dashboard. You can manage all the Database activities from here.
Database- In this section, you can see the database and table information of your blog. Here, you can easily find out which of your table has more records.
Backup DB- Here, you can backup your database on your server. You can either choose to GZIP or without compressing store it. This plugin automatically creates the folder in wp-content/backup-DB where all the backups are stored.
Note- After installing the plugin, please check whether the folder is automatically created or not if not then create it to avoid any loss.
Manage backup DB- Here, you can easily manage the backup database. You can delete it, restore it, download it or send it to your email address. If your database deleted, lost or anything weird happened then you can quickly restore it from here. Please restore the lasted database.
Optimise DB- You can quickly optimise your database table. Also, you get a choice to select the table to optimise.
Repair DB- You can repair your WordPress database if anything wrong happened. Here too, you will get a choice to select the tables.
Empty/drop tables- If you want to delete the entries from the specific table or drop the table, then you can do this here. I would suggest you be careful while doing anything here; otherwise, your blog will be a break.
Run SQL queries- Here, you can quickly run any queries on your tables.
DB option- In this section, you can configure the automatic schedule of backup the database. Here, you can schedule the backup, optimise and repair of the database. Here is what we are doing at ScrollBucks
Overall, by using this plugin, you will get all the option which is necessary to manage the database. Be careful while using this plugin because the database is the heart of the WordPress blog if anything wrong happened, then your blog will be in trouble(no problem you can restore the DB).
You can download the WP-DBManager plugin
If you like this short tutorial, then share it with your friends.
Latest posts by Amit Kharbade (see all)
- How To Track File Downloads in WordPress Site? - November 3, 2019
- How to configure the WP Mail SMTP plugin with Amazon SES? - October 20, 2019
- How to Log Your Emails in WordPress using WP Mail SMTP? - October 18, 2019