Change category ids in phpmyadmin

  • Hi guys,

    I already have read that is very difficult to change categories ids. But I really need to make this… or else I need 6 or 7 days to update all my posts.

    Please, can someone tell me how can do It?
    I notice that the categories number appears in the field term_taxonomy_id inside of table wp_term_relationships. I think that is here that he associates in posts.

    And in field term_id inside of table wp_terms appears the category id.

    But if I change that to the same id number, dont work… and the category name disappears from my wp-admin/categories.php

    Can someone give me a tip? ??

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter testept

    (@testept)

    Please, anyone?

    I had the same question. Have you had any success with this yet?

    Just out of curiosity, why do you want to change the id?

    I developed a template on my local computer that I wanted to transfer to a server, and the template included category-id template files. Therefore, I needed the category id’s to match between the two.

    In any event, I think I was able to make the changes in phpmyadmin successfully.

    In the tables, wp_terms and wp_term_taxonomy, I used an UPDATE query to change the field ‘term_id’ (which is essentially the category id) – and that seemed to work.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Change category ids in phpmyadmin’ is closed to new replies.