Remove UTW mysql tables?

  • 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?

Viewing 4 replies - 1 through 4 (of 4 total)

  • 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. https://www.ads-software.com/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!

    Thread Starter Matt Wiebe

    (@mattwiebe)

    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.

    Keilya

    (@fantasycrusader)

    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. (:

    Thread Starter Matt Wiebe

    (@mattwiebe)

    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…

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Remove UTW mysql tables?’ is closed to new replies.