How to completely clean up the information retained in the database by WordPress plugins

WordPress is currently the most widely used website and blog building program in the world. Its open source feature makes it very convenient for us to use. With a large number of plug-ins and themes, you can build one without knowing any professional technology. Your own website. However, after using it for a long time, it will inevitably bring about problems of one kind or another. Today, Snail will tell you about a problem that everyone may have faced, that is, how to completely clean up the information retained by the plug-in in the database. Although the plug-in is easy to use, , but many settings will automatically be stored in the database. Sometimes, although we uninstalled the plug-in, the plug-in settings still exist in the database. This is mainly manifested when we reinstall a plug-in and after enabling it, we find that the plug-in settings are inconsistent with the default ones. That's because you have used this plug-in before, and after enabling it, the settings in the database are automatically obtained. Plug-ins are changed over and over, and over time, one or another situation will inevitably occur. Here is how to completely clean up the information retained in the database by the WordPress plug-in. The method may be a bit clumsy, but the experts have better ways to advise.

1. Principle of plug-in database information clearing

The method used by Snail here is relatively simple and crude, because the plug-in settings are retained in the "wp_options" table of the database. We can delete the "wp_options" table that needs to be completely cleaned up on the blog, import a new "wp_options" table, and replace it. Implement cleanup. However, the theme settings and WordPress settings of our blog will be cleaned up accordingly, and we can only set them up one by one. Therefore, be sure to back up the database before performing the following operations.

2. How to clear plug-in database information

1. We first back up the database of the website where we need to clean up the plug-in database information. This is very important and must be done to avoid unnecessary losses caused by operational errors.

2. We can install a new WordPress program locally or on the server provider, and enter the database management page, as shown below. We first find the "wp_options" table, and then change the two website addresses in the red box in the picture below to You will want to clean the website URL and then export the “wp_options” table of the newly installed WordPress program’s database.

3. Log in to the WordPress site database management page that needs to be cleaned, follow the steps below to delete the "wp_options" table, and then import the new "wp_options" table saved in the second step. In this way, your WordPress site will be a brand new "wp_options" table, and all settings will be cleared.

Note: Be sure to back up your database! Be sure to back up your database! Be sure to back up your database!

Recommended site searches: ip proxy server, mainland China site group server, registration and cancellation, US server rental, US host rental, free virtual host, Hong Kong high-defense server, host space, US space, cn domain name price,