Support » How-To and Troubleshooting » v3.3.2 how to change category ID in phpMyAdmin?

v3.3.2 how to change category ID in phpMyAdmin?

  • Hello,

    I need to change the order (ID) of several categories in phpMyAdmin all of which have posts associated with them.

    Doing a search of the of WP website and some Googling, I found several threads on this but they are anywhere from 2 to 7 years old. The plugin mentioned ( [GWA] db Editor ) in a few posts which supposedly allows one to easily access their database to modify it hasn’t been updated since 2010.

    I’m not a database programmer but I can usually manage to follow explicit instructions on how to do things in phpMyAdmin.

    The most recent info I could find was for v2.7. Does anyone know how to do this that would share current instructions for v3.3.2?


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


    Moderator and Editor Customizer

    What exactly is it you are wanting to change? You can go into your database and modify single values manually. If you just need to change, for example, and ID number from 3 to 5, then you can easily do this from phpMyAdmin.

    I would recommend changing only one, and seeing the affects it has on any posts/pages. Remember the original setting in case things get messed up.

    According to everything I’ve read the category ID’s need to be edited in more than one place in the database. It’s not a simple one-step process. All the instructions I’ve found are for old versions of WP. I even found one by Googling who had a follow-up post that the method given didn’t work in WP v3.


    Don’t touch your DB unless you want to break everything beyond repair!!.

    Try this instead:

    Dashboard >> Posts >> Categories
    Now hove over the category shown on the right side and click on “Edit” or “Quick Edit”. these are only visible when you hover over the category item in question.

    There is bulk option as well but I believe you don’t want to change lots of them.

    Hope this helps.

    Unless I’m totally blind, you can change the category names here but not the category ID number which is what I need to modify. Thank you, though. I appreciate you trying to help me. 🙂

    [ Please do not bump, it’s not permitted here. ]

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘v3.3.2 how to change category ID in phpMyAdmin?’ is closed to new replies.