WordPress MU

I am still having a problem with the category slugs. They are all messed up now. what I am wondering is what happens if i delete all of the taxonomy table, and the sitecategories table from my WPMU database in PHPMyAdmin.

Will they just get recreated once I create the first category? OR Will it totally mess everything up?

Thanks for any help.

Totally mess everything up. It only creates those tables on install.

What if I renamed all 9 taxonomy tables that are currently created. Then created a new blog which would have a fresh table. Then finally copy that table into all 9 blogdir folders with the appropriate names?

I took the next step actually. I uninstalled MU entirely and then reinstalled and then recreated all the content.

What would have been easier would to have just "truncated" the 3 taxonomy related tables to remove the data. Deanna just meant that you shouldn't delete the tables themselves.

Hi MrBrian,

Well I did try truncating them first. I think I see why that didn't work though. There were 3? I truncated the table for each blog, and the sitecategories table. I didn't realize there was a third.

What is it for future reference, or for any one who might want to do the same?

Thanks again for trying to help.

don't delete the tables, in the myphpadmin, find wp_terms table and delete the data in it. This table contains all the categories and slugs including the unused slugs. By doing this, all your categories will be deleted so you'll need to create all new categories for your blog from the WP-admin page.

Noooo, don't do that. If you are going to remove the content from the wp_terms table, then you need to remove it from the related tables as well, or you are going to have very unpredictable results.

You need to remove content from
wp_x_terms
wp_x_term_taxonomy
wp_x_term_relationships

forgive me for the previous post.. I did made a mistake. Editing the wp_terms tables requires a really thorough analysis. Make sure you know every connections of terms in table wp_terms, taxonomy and relationships(as told by cafespain). I did made a mistake by deleting all content in wp_terms so I had to recreate every terms and relationships. Quite a messy job. If you do want to customize your category slugs, make sure you have some papers to list the terms you want to change and their relationships and make sure you understand what you're doing.