How to Delete Unused Database Tables in WordPress

-

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





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!


Comments

Post a Comment

Popular posts from this blog

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

-
Image
Google has recently introduced a Beta version of Google Search Console tool in which webmaster can easily find out their site insight and content indexing. Today in this article, we will discuss New Index coverage issue detected . After launching Beta version, Google is informed every webmaster about Index coverage issue detected via email. If Google has detected Submitted URL marked ‘noindex’ on your site and emailed you then do not ignore it. It may badly hurt your website SEO and Search Engine ranking. Here we are going to discuss with you how to fix Index Coverage Issue in webmaster tool. So let's start article....... How to fix New Index Coverage Issue Detected in Google search console tool First, log in to your Webmaster tool . Then click on the status >> Index coverage >> Submitted URL marked 'noindex '. Here Google will provide 4 ways ( Test Robots.txt Blocking, Fetch as Google, View as Search Result, Submit to Index ) to fix your affected URLs as you ca
Read more

Keep these 12 things in mind before applying to Google AdSense

-
Image
Do you want to earn a lot of money from Google AdSense but it is not easy to get AdSense approval . Here we will tell you some tips that you should use before applying to Google AdSense so that your Google AdSense application can be approved. Some common questions about Google AdSense, which often do bloggers search. How To Apply For AdSense ? How to get Google Adsense approval? I am eligible to apply for AdSense. What is Requirement for Google AdSense? Why AdSense account disapproved? In this article, we will answer you all these questions. This post is a bit longer but it is helpful for you. What is Google AdSense and why should you use it Google AdSense is a great advertising publishing network  owned by Google. It has millions of Satisfied Customers and Publisher. The biggest reason for this, AdSense always pays on time . Another reason to choose Google AdSense, if your blog has high-quality content then you can earn a lot of money through it. Today there are many bloggers who ar
Read more

Best Autoptimize Settings 2019 (Updated)

-
Image
Do you want to improve loading time of your WordPress site ? Well, there are many different ways to improve website loading speed, but today in this tutorial, I'll show you the best Autoptimize settings that optimize CSS and Javascript on your WordPress site and improve site performance  and page load speed. The main goal of the Autoptimize plugin is to minify your website's CSS and Javascript files and improve website performance. In addition, it also optimizes HTML files. So let's start the best Autoptimize settings... Best Autoptimize Settings 2018 Step by Step First, install and activate Autoptimize plugin in your site. After activating the plugin, click on Settings >> Autoptimize. This will take you to the settings page. Here you will see two settings - Basic and Advanced setting. Apart from this, you can configure CDN. Autoptimize Basic setting Here select all checkboxes and click the Save changes button. When you click on Save button after completing Autoptimi
Read more