Changing a Tax term ID in pHp my admin/mySQL help

  • I have one term that is a custom taxonomy term, nonhiarchal, Wednesday id=>5 i want it to be an id=>40. the ID of 40 is available meaning no term associated with it. https://codex.www.ads-software.com/WordPress_Taxonomy according to this, i need to only update a term id in 2 places wp_terms and wp_term_taxonomy. So if I change id=>5 to id=>40 in those two tables, do you think the site will still function correctly? I am currently researching this but so far no info. I suppose I can experiment then just resore the old DB if it doesn’t work…
    Thanks in advance

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter joeyjosay

    (@joeyjosay)

    Well, changed the term_id in both both tables and it seems to working fine and using 40 ad the new term_id across the board. Hope this helps someone in the future.

    Moderator bcworkz

    (@bcworkz)

    I can confirm that is fine, if there are no references to the old ID elsewhere, and provided the term tables’ automatic indexing has already passed 40. If not, there may be a problem when it does reach 40. To be safe if it hasn’t reached 40 yet, set the auto indexing to 41 so all new insertions are higher. This is done in phpMyAdmin. Go to each table, then go More > Operations > Table Options > AUTO_INCREMENT

    If the old term ID in the term_taxonomy table has a count > 0, then there are other references for sure and they need to be corrected as well. Even if the count is 0, that does not mean there are no other references.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Changing a Tax term ID in pHp my admin/mySQL help’ is closed to new replies.