WordPress.org

Forums

v3.3.2 how to change category ID in phpMyAdmin? (5 posts)

  1. MouseClicks
    Member
    Posted 3 years ago #

    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?

    Thanks,
    MC

  2. 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.

  3. MouseClicks
    Member
    Posted 3 years ago #

    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.

  4. playing2012
    Member
    Posted 3 years ago #

    @MouseClicks

    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.

  5. MouseClicks
    Member
    Posted 3 years ago #

    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. ]

Topic Closed

This topic has been closed to new replies.

About this Topic