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 optimization, 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 as all in one DB manager. Personally, I am using this plugin since long ago. I like all the features which WP-DBManager offers. It’s free plugin anyone can take advantage of it.
WP-DBManager allows us to optimize 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, optimize of your database. Let’s discuss this 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 easily restore it from here. Please restore the lasted database.
Optimize DB- You can quickly optimize your database table. Also, you get a choice to select the table to optimize.
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 simply 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 easily 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, optimize 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 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.