• Home
  • About John P.
  • Contact
  • Terms
  • Facebook
  • Google+
  • Instagram
  • LinkedIn
  • Pinterest
  • StumbleUpon
  • Twitter
  • YouTube

One Man's Blog

Specialization is for Insects.

  • 10 Best
  • Art
  • Computing
  • Fun Stuff
  • Gadgets
  • Videos
  • Photography
  • Travel
  • Tutorials
  • Health & Fitness
  • Politics
  • Thoughts
  • Food
  • Reviews
  • 10 Best
  • Art
  • Computing
  • Fun Stuff
  • Gadgets
  • Videos
  • Photography
  • Travel
  • Tutorials
  • Health & Fitness
  • Politics
  • Thoughts
  • Food
  • Reviews
Home / Wordpress / Clean Up Your WordPress 2.3+ Database after Ultimate Tag Warrior

Clean Up Your WordPress 2.3+ Database after Ultimate Tag Warrior

John P.

September 5, 2008 By John P.

WordPress Database ManagementThis 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.

Related

Filed Under: Wordpress Tagged With: Plugins, Tutorials, Wordpress

About John P.

John P. is a former CEO, former TV Show Host, and currently an unemployed bum. You can find him on Twitter, Facebook and Google+. Feel free to send shoutouts, insults, and praise. Or Money. Money is good.

Comments

  1. Nancy Man says

    February 23, 2013 at 3:25 am

    Thanks for this! I’ve had those tables sitting in my database for years now. Finally got rid of them just now. :)

  2. jermaine says

    July 15, 2009 at 3:28 pm

    I have been blogging now since version 2.1 and was told that this plug in going to do wonders. it did it left lots of tags some of which was useful but many almost unrelated to what I was looking for.

    after one upgrades I decided on one blog to copy the database and then deleted the whole blog and set it up again. rather severe option looking back and a waste of time as the tags were still in the database. Never again. Now this new db manager plug has solved the problem and it is time to move on.

    Thanks for this advice

  3. thinkflick says

    December 16, 2008 at 5:22 am

    I love to learn posts like this as I’m great learner of wordpress these days. I found wordpress section here and thinking to read other posts too. :)

@johnpoz on Instagram

johnpoz

Instagram post 2159071784169677252_868291 Ok, what we're gonna do, see, is jack this bitch up so high you need a ladder to get in it. Then put low profile tires on it.

Makes sense.
Instagram post 1651683388997198077_868291 Let them eat turkey... I mean cake.
Instagram post 1594542660127178371_868291 Need I say more?
Instagram post 1586584715854724617_868291 Cleaned my vehicles with @ArmorAllUSA Ultra Shine Wash Wipes. Here's the story! http://onemansblog.com/ultrawipes

#ArmorAll - #Ad - #YeeHaw
Instagram post 1583839624509710481_868291 Tomorrow I'm getting my new forklift from @quality_equipment! Can't wait to start forking stuff. ;-)
Instagram post 1483557512108462059_868291 Aaarrgh! What should I choose?
Instagram post 1332177423181111343_868291 Have I died and gone to heaven?
Instagram post 1315216644179506537_868291 Hard boiled chili quail eggs anyone?
Instagram post 1304017255566633787_868291 I'll take two!
Instagram post 1271354042084454476_868291 This exists.
Instagram post 1269750352793792868_868291 Over two pounds of pizza!
Instagram post 1265414420636594555_868291 Where should I start?
Instagram post 1265385838451322970_868291 Give it a minute. You'll get it...
Instagram post 1240070085028312054_868291 Image for post 1240070085028312054_868291
Instagram post 1219268260050203419_868291 Image for post 1219268260050203419_868291
Instagram post 1215376694143316900_868291 It'll tickle yore innards!
Instagram post 1214775572231844624_868291 Image for post 1214775572231844624_868291
Instagram post 1208266011039723853_868291 The @genyhitch is a massive 80 pound drop hitch with a bonus - it can absorb the shock from twists, turns and bumps in the road, providing cushioning for both the tow vehicle and whatever it's pulling.
Instagram post 1204521118366658866_868291 Who's up for some ghost pepper powder in their salt?
Instagram post 1178517226701156973_868291 Downloading at around 140 MB/S.  That's a full Gigabit download speed from the World of Warcraft servers to the new @Acer Predator desktop machine.
Load More... Follow on Instagram
Tweets about johnpoz

Copyright © 2019 · Genesis Framework · WordPress · Log in

Follow Along for E-Mail Updates
Don't miss any of John P's craziness! Just shove your email address in the slot below and we'll take care of the rest! :-)
Arrow

Email: