Did you know that when you delete a plugin from WordPress dashboard, it may not necessary meant the complete removal of the unwanted plugin? The reason is because the plugin developer did not take the effort to create a proper un-installation script for the plugins. As a result, your WordPress database table wp_options get bloated with unwanted plugin options. Your plugin’s options are mainly settings and data stored in your wp_options table.
wp_options database table typically contains settings and data on:
- blog (e.g. siteurl, blog name, blog description),
- post, widget, thumbnails,
- plugins, and more
If you are curious and want to know more about the structure of WordPress databases, you can read more here.
Before we begin
Do ensure that you have done the full backup on your blog files and database, be you start to remove wordpress plugin options. Also, we can only delete plugin options when the unwanted plugin is already deleted from your blog.
This guide will show you two ways on how to remove your WordPress plugin options from the wp_options table:
- either using phpMyAdmin,
- or WordPress plugins that are designed to clean up wp_options.
Using phpMyAdmin to Remove Obsolete Plugin Options
- To remove obsolete plugin settings/options from our wp_options table, we need to login to our hosting account control panel first.
- In this example, the screenshots below are shown from Hostgator cPanel. It should be similar to your web hosting account too. Once you have login to your hosting control, look for phpMyAdmin, and click to access.
- Click on the + sign located on the left-hand side of phpMyAdmin. This will expand and show you all the tables available. Look for the table wp_options.
- From the wp_options page, you will see rows and rows of data (see picture below). To remove obsolete plugin options, you need to go through the list to identify those suspicious ones. If you have knowledge on what are the plugins options to delete (e.g. plugins that you recently deactivated & transients options), you can quickly get down to it by using Filter Rows.
- Once you found the row containing the obsolete plugin option, click on Delete (located within the row) to remove it.
- As this may be tedious and prone to errors, we usually recommend a quicker way which is to use Wordpress plugins that are designed to clean and optimize databases. Read on further for more information and how-to.
Using WordPress Plugin to Remove your Obsolete Plugin Options
There are a number of WordPress plugins that you can use to clean up, however in this guide, I will be illustrating with WP Sweep.
- Install WP Sweep if you have not, then access it from your WordPress dashboard, Tools > Sweep.
- Within the WP Sweep dashboard, scroll down and look for Option Sweep. The WP Sweep plugin will show you the number of transient options. Once you are certain the options are no longer in use, you can proceed to remove them by clicking on the button Sweep.
- Repeat the process regularly, or whenever you need to, to weed out obsolete plugin options.
Constant optimizing and cleaning up WordPress blog are necessary routines and cannot be over emphasized. Since you are on this, you should optimize and clean-up your database further by removing obsolete or orphaned tables.
Last but not least, if have the intention to re-install and use the WordPress plugin again, then probably you may just want to have it status quo.
Latest posts by lincoln (see all)
- Twitter Search Operators for Geeks – Change the Way You Search - April 21, 2016
- How to Auto Publish from Instagram to WordPress Using Instagrate - April 19, 2016
- 20 Best Ways to Use Twitter Advanced Search to Find Leads - April 17, 2016