How to Clean WordPress Database using Advanced Database Cleaner Plugin?

Want to clean your WordPress website database? Then here it is.

In this guide, you will learn how to easily clean a WordPress website database using Advanced Database Cleaner Plugin. Advanced Database Cleaner Plugin allows you to clean, optimize, repair and delete database tables in just a few clicks. This plugin is simple and easy to use.

With the Advanced Database Cleaner Plugin you can do the following tasks:

• Clean all post revisions – each revision to a post creates another entry in the wp-posts table, but you can delete old revisions to save space.
• Clean all auto-draft posts – this is where WordPress creates an automatic draft post. Often these are created and never used, but they still remain in the database!
• Clean all trashed posts – does what it says, removes all posts that have been marked as trash, thereby cleaning more data out of the database.
• Remove spam and trashed comments – again, does what it says, thereby clearing the database of useless information.
• Remove Orphaned data – deletes Orphaned data which becomes unused for WordPress.
• Remove unapproved comments – to keep the database as lean as possible and save the need for this to be done manually in the WordPress admin back-end.

Installing Advanced Database Cleaner Plugin

Advanced Database Cleaner Plugin is a free plugin available on WordPress.org

To install and activate the plugin all you need to do just

1. Login to WP Admin and go to Plugins>Add New.
2. Search for Advanced Database Cleaner.
3. Install and activate the plugin.
   
4. Alternatively, you can download the plugin from the WordPress Plugin directory and upload it to the WordPress site.

How to Use Advanced Database Cleaner Plugin?

There are 3 main settings in which we’re interested when looking at the Advanced Database Cleaner plugin. They are:

1. General clean-up
2. Tables Cleanup
3. Cron Jobs

NOTE: Make sure to take a backup of your WordPress site database before doing any optimization directly to the database. It is always better to be safe than sorry!

General clean-up

General clean-up is the main use of this plugin. You can delete post revisions, spam comments, trashed comments, etc from this section. Removing this unnecessary data will reduce your database size, speeds up your backup process and speeds up your site also.

From General clean-up you can:

• Delete old revisions of posts and pages
• Delete old auto drafts
• Delete trash posts
• Delete pending comments
• Delete spam comments
• Delete trash comments
• Delete pingbacks
• Delete trackbacks
• Delete orphan post metadata
• Delete orphan comment metadata
• Delete orphan user metadata
• Delete orphan term metadata
• Delete orphan relationships
• Delete expired transients

You can check all the boxes here and select the Clean option from the dropdown. Then Apply.

Tables Clean up

This section is for your WordPress tables management. These are options for cleaning up WP tables. These are:

• Optimize: For optimizing WordPress database tables.
• Repair: For repairing broken database tables.
• Empty Rows: To empty the database table rows.
• Delete: To delete particular WordPress database tables.

Cron Jobs

From this section, you can select a particular hook and delete the corn job hook. You can also check the Arguments, Next run – Frequency of the cron job.

FAQs

Conclusion

With simple and easy to use UI Advanced Database Cleaner is a great choice for all kinds of WordPress websites. This plugin also offers a premium version. However, the free version is enough for small and medium sized websites. Go and give it a try!

Like this article? Do share it with your friends on social media.

---

Subscribe to WebsiteQna

* indicates required

Email Address * You are subscribing to email updates. Unsubscribe anytime.

RELATED: