Aug 062019
 

WP Database Cleaner Plugin tutorial shows you how to manage and maintain a clean and optimize database using this great plugin.

Last Updated: September 4, 2020

Latest News: Updated the documentation.

clean-and-optimize-wordpress-database-plugin

Advanced Database Cleaner plugin is simple and easy to use and setup. It has many potential features that help you maintain and optimize your database without having to leave your admin site. It is a simple plugin for users who don’t have any database knowledge and don’t know how to log into their server and use phpMyAdmin or something similar to clean the database.

This tutorial list below will show you how to set up and use Advanced Database Cleaner plugin.

Advanced Database Cleaner changelog 3.0.2

  • Fix: fixing an issue in the general cleanup tab preventing users from deleting orphaned items
  • Tweak: we are now using SweetAlert for all popup boxes
  • Tweak: enhancing the JavaScript code
  • Tweak: enhancing some blocks of code
  • Tweak: enhancing the security of the plugin

What You Need:

WP Database Cleaner Tutorials:

Note: These tutorials a based on version 3.0.0.

WP Database Cleaner Plugin

Warning: Before you begin, make sure you create a database backup of your site. Just in case something goes wrong.

Before You Begin

Make a note of the following list of 12 default tables used by WordPress. These 12 tables exist in your site, before other tables are added by plugins or theme/s. It is important that you make a note of this. It can help you make sure you don’t delete any of these default WordPress tables by accident.

Note: Click the following link Database Description to learn more. 

Default WordPress Tables

  • wp_options
  • wp_users
  • wp_links
  • wp_commentmeta
  • wp_term_relationships
  • wp_postmeta
  • wp_posts
  • wp_term_taxonomy
  • wp_usermeta
  • wp_terms
  • wp_comments
  • wp_termmeta

Step 1 ) Go to WP DB Cleaner as illustrated in the image to start setting up the plugin.

wp-database-cleaner-plugin-admin-panel-new

Step 2 ) The following image shows you the different admin tabs available for you to setup and help you keep your database clean and optimized.

WP DB Cleaner Admin Tabs

  • General clean-up
  • Tables
  • Options
  • Cron Jobs
  • Overview & Settings
  • Premium

wp-database-cleaner-admin-tabs-new

General clean-up

Step 3 ) Go to WP DB Cleaner -> General clean-up as illustrated in the image below to clean up the following options. In the following list you can see 3 different elements that need attention.

General clean-up Options

  • Revisions 13 view = There are 16 revisions that can be cleaned.
  • Drafts 1 view = There is 1 draft that can be cleaned.
  • Auto Drafts 1 view = There is 1 auto draft that can be cleaned.
  • Trash posts
  • Pending comments
  • Spam Comments
  • Trash comments
  • Orphan Postmeta
  • Orphan Commentmeta
  • Orphan Relationships
  • Dashboard Transient Feed

wp-database-cleaner-general-clean-up-options

Step 3-a ) The following image lets you know of any elements that can be cleaned. It also allows you to add new General clean-up scheduled options by clicking on Add new schedule button.

wp-database-cleaner-general-clean-up-schedule-options-new

Tables

Step 4 ) Go to WP DB Cleaner -> Tables as illustrated in the image below to check and delete any obsolete tables from your database if there are any.

Tables List Options

  • All (42) = In this example you can see 42 tables in this database.
  • Uncategorized (42)
  • Orphan (*) = Only available in the pro version.
  • Plugin options (*) = Only available in the pro version.
  • Themes options (*) = Only available in the pro version.
  • WP options (*)  = Only available in the pro version.
  • The search filtering is only available in the pro version.
  • Items per page

wp-database-cleaner-plugin-tables-tab-options-new

Step 4-a ) The following image allows you to select from the following options. When you you select a database table, you can carry out one of the tasks listed below.

Tables Drop Down Menu Options

  • Optimze
  • Repair
  • Empty rows
  • Delete

wp-database-cleaner-plugin-tables-tab-drop-down-options

Step 4-b ) The following image shows you a clear warning message before you click on Continue button to delete a table from your database.

wp-database-cleaner-plugin-tables-tab-cleaning-message

Step 4-c ) The following image lets you know if your database is optimized or not. It also allows you to add new General clean-up scheduled options by clicking on Add new schedule button.

wp-database-cleaner-table-schedule-options

Options

Step 5 ) Go to WP DB Cleaner -> Options as illustrated in the image below to check and delete any obsolete options if there are any.

Tables List Options

  • All (265) = In this example you can see 265 entries in the options table in this database.
  • Uncategorized (265)
  • Orphan (*) = Only available in the pro version.
  • Plugin options (*) = Only available in the pro version.
  • Themes options (*) = Only available in the pro version.
  • WP options (*)  = Only available in the pro version.
  • The search filtering is only available in the pro version.
  • Items per page

wp-database-cleaner-optomize-tab-options-new

Step 5-a ) The following image allows you to select from the following options. When you you select a table entry from the options tab, you can carry out one of the tasks listed below.

Drop Down Menu Options

  • Delete
  • Set autoload to yes
  • Set autoload to no

wp-database-cleaner-option-tab-drop-down-options

Cron Jobs

Step 6 ) Go to WP DB Cleaner -> Cron Jobs as illustrated in the image below to check and delete any cron jobs not needed any more.

Cron Jobs Options

  • All (12) = In this example you can see 12 cron jobs available.
  • Uncategorized (12)
  • Orphan (*) = Only available in the pro version.
  • Plugin options (*) = Only available in the pro version.
  • Themes options (*) = Only available in the pro version.
  • WP options (*)  = Only available in the pro version.
  • The search filtering is only available in the pro version.
  • Items per page

Overview & settings

Step 7 ) Go to WP DB Cleaner -> Overview & settings as illustrated in the image below to check and see what is going on in the backend of your database.

Note: Click the following link wp-database-cleaner-overview-and-settings to learn more.

wp-database-cleaner-plugin-overview-settings-tab-options

Premium

Step 8 ) Go to WP DB Cleaner -> Premium tab to learn more about the premium options.

The above steps should help you maintain an optimize and cleaner database for your site.

If you have any questions please let me know. I will be updating this post from time to time. So keep coming back for the latest.

Enjoy.

I have been working in IT since 1999 and I enjoy the challenges it brings me. I love developing websites with WordPress. I spend a lot of time helping out in wordpress.org forums. I have been writing tutorials since 2011. Now I am learning how to manage my own VPS "Virtual Private Server.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)

We use cookies in order to give you the best possible experience on our website. By continuing to use this site, you agree to our use of cookies.
Accept
Reject
Privacy Policy