background img
Jun 13, 2020
227 Views
0 0

How to Delete Unused Database Tables in WordPress

Written by

Do you want to delete old database tables in your WordPress site? The WordPress site stores any information in the database which increases the size of the database. When you install and activate a plugin or theme in your WordPress site, it automatically adds tables to your WordPress database.

But when you disable and uninstall the plugin, it does not delete the database tables. To completely uninstall a WordPress plugin from your site, you must also delete the database tables, folders, and files created by that plugin.

In this tutorial, I will show you how to delete Unused Database Tables from a WordPress site.

So let’s start…

How to Delete Orphan Tables in WordPress Database

Deleting Unused Database Tables from a WordPress site is not a difficult task. You can remove Unused Tables from your database in a few minutes. Here I will tell you about two plugins to remove orphan tables (Unused Database Tables) which work perfectly.

Note: Before clearing the Old Unused Database Tables from your site, backup your database so that you can restore your database again if there is a problem.

# 1. Deleting Unused Database Tables Using Plugins Garbage Collector

First of all, install and activate the Plugins Garbage Collector plugin on your site.

Plugins Garbage Collector scans Unused Database Tables in your WordPress database. If your blog is very old, there may be some Unused Database Tables in your WordPress database. With this plugin, you can check Orphan Tables and delete them.

After the plugin is activated, it will add a new menu item inside the Tools menu with the label Plugins Garbage Collector label. Just click on Tools >> Plugins Garbage Collector. This will take you to the settings page of the plugin.

Here check the box of Search none-WP tables and Show hidden tables then you can click on Scan Database.

Tables in WordPress

After the scan is complete, you can delete the unused plugins tables from the database. The plugin does not display database tables related to WordPress core or installed plugins.

Select the tables you want to delete. Then, scroll down and you can click on the “Delete Tables” button. After deleting the unused old database tables, it will notify you like this – Tables are deleted successfully: ytmah_rank_math_redirections_cache

congratulation! You have deleted Orphan Tables from your WordPress database.

You can use the WP-Optimize plugin to make your database clean and optimize.

#2. Deleting Unused Database Tables Using Advanced Database Cleaner

To delete Orphan Tables from WordPress database is a very popular and highly rated plugin.

First of all, install and activate Advanced Database Cleaner on your site. This plugin removes orphaned data like old revisions, old drafts, unused database tables etc. from your site.

After the plugin activates, it will add a new menu item to your WordPress dashboard with WP DB Cleaner. Just click on it. This will take you to the settings page of the plugin.

Here go to the Tables tab and click on Detect orphan tables. This will start detecting unused database tables.

Tables in WordPress

Check the Unused Database Tables and select the Delete option from the drop-down menu, then hit the Apply button.

Tables in WordPress

congratulation! Advanced Database Cleaner from your database
orphan tables have been deleted.

To optimize your database, even more, go to the General clean-up tab, then choose the Clean option from the drop-down menu and click on the Apply button.

The conclusion (Tables in WordPress)

To reduce database size and improve website speed, it is very important to delete Unused Database Tables.

In this article, I told you about two plugins to delete orphan tables from the database. Both plugins are very easy to use and you can use anyone.

Once again I want to tell you, before using the plugin, back up your database and you should know which database tables you are removing.

If this article has proved helpful for you, then don’t forget to share it!

Also Read:

 

Article Tags:
Article Categories:
WordPress

Leave a Reply

Your email address will not be published. Required fields are marked *


The maximum upload file size: 300 MB.
You can upload: image, audio, video, document, text, other.
Links to YouTube, Facebook, Twitter and other services inserted in the comment text will be automatically embedded.