This post is for a very select group of people. Namely, bloggers who have been using WordPress since before version 2.3, and specifically those who were using the UTW (Ultimate Tag Warrior) plugin.

In version 2.3, WordPress introduced native “tagging”, which is what enables those little tag links you see below this post. Prior to that, those of us who wanted to use tags had to turn to an external plugin – the most popular of which was UTW.

When the upgrade to WordPress 2.3 occurred, it allowed us to import our existing tags into a different table in the database, but it did not delete the old UTW table even if you uninistalled the plugin. Here is how you can go ahead and clean up your database to keep things neat and tidy and running smooth.

First of all, you need to download and install Lester Chan’s WP DB Manager plugin. It allows you to optimize, repair, backup, and restore your database as well as drop/empty tables and run selected queries. It also supports automatic scheduling of backing up and optimizing of database.

After you’ve installed it and played around with it a bit (optimized and backed up your database!), you should go into the “Empty/Drop Tables” tab so you can remove the old UTW tables from the database.

The tables that you should delete are:

• wp_post2tag
• wp_tag_synonyms
• wp_tags

I personally dropped wp_tags, wp_post2tag and wp_tag_synonyms with no problems, but of course I’m not going to guarantee that you won’t have any yourself (though I’m 99% certain you should be OK). The only things you must remember are:

1. Make sure you’ve imported your UTW tags into wp2.3 first!
2. Back up your database before doing this

My thanks to MattWeibe for documenting this on the WordPress support forums so I didn’t have to test it by myself first. And of course to Lester for his excellent and simple to use plugin.

Oh, and as a gift with purchase, I also highly recommend the WordPress Clean Options Plugin to help you continue to keep your database nicely trimmed.

Tags: Plugins, Tutorials, Wordpress

Related posts

1. WordPress Custom Database Error PagesIf you’re running WordPress 2.3.2 or later, there is a new feature that allows you to to specify an error...
2. No Ping Wait Wordpress PluginThe useful No Ping Wait Wordpress plugin was created by by Robert Deaton, but due to an apparent hardware failure...
3. Complete List of OMB WordPress PluginsI recently completed the upgrade to WordPress 2.3 and thought it was about time I gave some credit where credit...
4. Google Translate Wordpress Plugin The Google Translator plugin allows Wordpress to add a number of alternate languages to your blog. This plugin is...
5. Tutorial: What To Do When WordPress Auto-Update FailsI don’t know about the rest of you, but I’ve experienced many instances where the Auto-update feature in WordPress fails...
6. Wordpress Plugin: WP Admin Bar ReloadedNOTE: This plugin has been abandonded in favor of Viper’s better WordPress Admin Bar. Go get it!!! WP Admin Bar...
7. WordCamp 2007: HyperDB and High Performance WordPressWhat do you do when your blog goes from a thousand pageviews a day to a million? Well, you start...