Some tables gets left behind in WordPress database by uninstalled WordPress plugins. Unless you need the data in those tables for some reason, it is best to find and remove such unused tables as they are just lying around and occupying unnecessary space. It is also recommended for an optimized WordPress database. While you can connected to the database and inspect manually and remove, it may be tedious and you need to know exactly which tables are unused. And there are chances of error in manual process. But luckily, there are useful WordPress plugins which can help us to do just that. In this post, we shall see How To Find and Delete Tables Left Behind By Uninstalled Plugins in WordPress.
How To Find and Delete Tables Left Behind By Uninstalled Plugins in WordPress
You can watch this short video How To Find and Delete Tables Left Behind By Uninstalled Plugins in WordPress. If you would like to read, skip the video and read below.
To find and delete such unused zombie tables, you can use WP-OPTIMIZE WordPress plugin. The plugin allows you to easily find and remove unused tables from WordPress database.
First, install and activate the WP-OPTIMIZE WordPress plugin.
After that, go to WP-OPTIMIZE > DATABASE > TABLES
Refresh the data and inspect the tables listed. If there are tables left behind by some plugins, then you will see REMOVE button on the right-most column. You can check the name of the table, which plugin left it behind.
After confirming that you do not need the table, click on REMOVE to remove the table.
Repeat the same process for other unused tables which may be shown there.
So, using this useful WordPress plugin, you can clean up unused WordPress tables left behind by uninstalled WordPress plugins.
WP-OPTIMIZE also includes other useful features such as :
- clean and optimise your database.
- compress your images.
- cache your pages, for super fast load times
# how to delete unused tables in wordpress database
# clean zombie tables in wordpress database
# database tables optimize wordpress