WordPress.org

1. mattwiebe
   Member
   Posted 2 years ago #

   Question: I've ugraded to 2.3, moved all of my UTW tags into the native tagging structure, and I'd like to clean up my mysql database. As far as I can tell, the tables that I should delete now are:

   wp_post2tag
   wp_tag_synonyms
   wp_tags

   Of course, it goes without saying that I'll do a backup before doing this...

   For bonus points: what do I delete out of the Options table?

2. sahaskatta
   Member
   Posted 2 years ago #

   i think you can delte wp_post2tag and the synonyms one, but don't telete the wp_tags. i think that is part of 2.3.

   As for cleaning the options table. just get the clean options plugin. http://wordpress.org/extend/plugins/clean-options/

   i had some problems with running it on 2.3, but it will at least bring up a list of all the unnecessary items in the options and you can then go into phpmyadmin and delete them yourself!

3. mattwiebe
   Member
   Posted 2 years ago #

   thanks sahaskatta, i'll look into that plugin

   after further exploration, i think that wp_tags is utw-specific. wp2.3 is storing both tags and categories within wp_term_* tables.

4. fantasycrusader
   Member
   Posted 2 years ago #

   Thanks for asking what I would have asked. I've also dropped both the wp_tags and wp_post2tags tables with no errors so far. (:

5. mattwiebe
   Member
   Posted 2 years ago #

   Just to conclude my mini-quest, I dropped wp_tags, wp_post2tag and wp_tag_synonyms with no problems at all.

   Just make sure that you've already imported your UTW tags into wp2.3 first! And of course, back up before doing anything crazy like this...

Topic Closed

This topic has been closed to new replies.