• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer

JUST BRIGHT ME

Makes WordPress and SEO Easier

  • Start Blog
  • Blogging
  • SEO
  • WordPress Guide
Home » WordPress Guide » How to Delete Unused Database Tables in WordPress

How to Delete Unused Database Tables in WordPress

Written by AMAN SINGH

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

But when you disable and uninstall the plugin, it can not remove database tables. To completely uninstall a WordPress plugin from your site, you need to delete database tables, folders and files.

In this tutorial, I’m going to share how to clear old database tables in wordpress site.

So, let’s get started…

  • How to Delete Orphan Tables from WordPress Database
    • #1. Delete Unused Database Tables Using Plugins Garbage Collector
    • #2. Delete Unused Database Tables Using Advanced Database Cleaner
    • Conclusion

How to Delete Orphan Tables from WordPress Database

Deleting orphan tables from database is not a hard task. You can delete in a few minutes. Here I will tell about two plugins to delete orphan tables from database that work perfectly.

Note: Back up your database before deleting unused database tables from your site. So you can restore your database again if there is a problem.

#1. Delete Unused Database Tables Using Plugins Garbage Collector

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

Plugins Garbage Collector scans your WordPress database for orphan tables. If your blog is older, then your WordPress database might have some unused plugin tables. With this plugin, you can check your database for orphan tables and delete them.

Once activated, it’ll add a new menu item under tool with Plugins Garbage Collector label. Just click on Tool >> Plugins Garbage Collector. This will take you to the plugin’s settings page.

Here check the box of Search none-WP tables and Show hidden tables then click on Scan Database. Also, plugin searches WP tables structure changes.

How to Delete Unused Database Tables in WordPress

After getting the result, you can remove 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 click on the “Delete Tables” button. After deleting unused old database tables, it will notify you like this – Tables are deleted successfully: ytmah_rank_math_redirections_cache

Congratulation! You have successfully deleted unused database tables in your WordPress site.

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

#2. Delete Unused Database Tables Using Advanced Database Cleaner

This is also very popular and highly rated plugin to clear old database tables in WordPress.

First, install and activate Advanced Database Cleaner plugin on your site. This plugin deletes orphaned data such as old revisions, old drafts, optimize database and many more.

Once activated, it will add new menu item in your WordPress dashboard with WP DB Cleaner. Just click on it. This will take you to the plugin’s settings page.

Here navigate to Tables and hit on Detect orphan tables. It will start detecting unused database tables.

How to Delete Unused Database Tables in WordPress

Check your Orphan Tables and select the Delete option from the drop-down menu then hit on Apply button.

How to Delete Unused Database Tables in WordPress

Congratulation! Advanced Database Cleaner has deleted orphan tables from your Database.

To further clean and optimize your database navigate to the General clean-up tab, then select the Clean option from the drop-down menu and click on the Apply button.

Conclusion

To reduce your database size and improve website speed, you should delete old database tables that are not being used.

Here are two plugins recommended to delete Unused Database Tables. Both plugins are very easy to use and you can use anyone.

Before using the plugin, back up your database and you should know which database tables you are deleting.

Comment below to share your thoughts and experiences about removing orphan tables from the database.

We’re done, and it’s now your turn! Find this article helpful? Don’t forget to share!

About AMAN SINGH

AMAN SINGH, who owns JustBrightMe, is a full-time blogger and loves sharing content on WordPress, SEO & Blogging Tips.

Reader Interactions

Leave a Reply Cancel reply

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

Primary Sidebar

Blog’s Popular Post

How To Increase Website Traffic in 2021 (54 Working Methods)

The Ultimate On-Page SEO Techniques

Best Autoptimize Settings Updated

Fix Submitted URL marked ‘noindex’ in Google Search Console Tool

How to Protect Your Website from Negative SEO

76 Best Free Responsive Blogger Templates

Rank Math SEO VS Yoast SEO Comparision

650+ High Domain Authority Sites to Get Dofollow Backlinks

How to Transfer SBI Account from One Branch to Another Branch

16 Free Ways to Promote Your Website

Blog’s Recent Post

How to Get Google to Instantly Index Your Website

How to Increase Domain Authority 2021

How to Change Name in Aadhar Card Online

How To Get Free Domain For Your Website

20 Ways How to Speed Up WordPress Site

How to Change Mobile Number in SBI

How to Unlock a PUK Blocked Sim Card

How to Remove Image Background Online in One Click

How to Block SBI ATM Card

How to Disable Windows Defender in Windows 10

Footer

SEO Guides

  • Learn SEO: A Beginner’s Guide to SEO
  • 40 Google Ranking Factors
  • How to Create Quality Backlinks
  • How to Improve Google Ranking
  • 23 Best On-Page SEO Techniques
  • How to Keyword Research for SEO
  • 29 Most Common SEO Mistakes to Avoid
  • How to Increase Domain Authority
  • Image SEO Tips You Need to Know
  • Keyword Density in SEO
  • Internal Linking for SEO
  • How to Protect Website from Negative SEO

WordPress Guides

  • How to Create a Blog on WordPress
  • Top 25 Must-have WordPress Plugins on Every Blog
  • 34 Best SEO Friendly WordPress Themes
  • 42 Most Common WordPress Mistakes to Avoid
  • How to Speed Up WordPress Site
  • 19 Essential Settings After Installing WordPress
  • 57 Best Responsive WordPress Themes
  • Top 41 Fast Loading WordPress Themes
  • How to Scan WordPress Site for Malware

Useful Guide

  • How To Increase Website Traffic (54 Working Methods)
  • A Complete Guide to Google Search Console
  • 20 Ways How to Reduce Bounce Rate
  • 46 Killer Blogging Tips for Beginners
  • How to Become a Successful Blogger
  • 50 Best SEO Tools (Ultimate List)
  • 16 Free Ways to Promote Your Website
  • 11 Best Blogging Platforms to Launch a Blog in 2020
  • How to Update Old Blog Posts (and Why You Should)

© 2021 · JUST BRIGHT ME

  • About us
  • Privacy Policy
  • Sitemap