I use the WP-DBManager plugin to keep my WordPress databases clean. I like things neat and tidy, so it annoys me when I see unnecessary tables in my WordPress databases. These are often left over from deleted plugins. Some plugins delete their data from the database, but many don’t, preserving your data in case you reinstall the plugin. Here’s how to drop unwanted tables with the WP-DBManager plugin.
Note: before working on your database, always make a backup! You can do this with the WP-DBManager plugin, or use a backup plugin like my favorite, BackWPup.
- Install and activate the WP-DBManager plugin. You’ll have a new Database item in your admin menu.
- From the Database menu, select Empty/Drop Tables.
- Select the Drop radio button for any tables you wish to drop.
- Click the Empty/Drop button at the bottom.
At the bottom of the page is this note: “1. EMPTYING a table means all the rows in the table will be deleted. This action is not REVERSIBLE. 2. DROPPING a table means deleting the table. This action is not REVERSIBLE.”
The plugin does a lot more than drop tables. The description says, “Allows you to optimize database, repair database, backup database, restore database, delete backup database , drop/empty tables and run selected queries. Supports automatic scheduling of backing up, optimizing and repairing of database.”
How do you keep your WordPress databases clean?