[resolved] Update starting post ID? (3 posts)

  1. supernovia
    Posted 6 years ago #


    I've just imported about 400 items from a Nucleus blog, and have changed all my post IDs to match the old item IDs from Nucleus.

    Because of the way Nucleus handles things though, there are some gaps in the increments. I was wondering if there's a way to force WordPress to start incrementing new post IDs with a higher number so they won't conflict with the old numbers.

    Is there a way to force it to make my first WordPress post id 500 (for example), and then increment from there?

  2. supernovia
    Posted 6 years ago #

    (As to why in the world I'd go through the effort to change all my IDs, it's so I can do a 301 redirect from the old links to the new)

  3. supernovia
    Posted 6 years ago #

    Got it ...

    ALTER TABLE wp_posts AUTO_INCREMENT = 500;

    Obviously you'll want to make sure your number higher than any of your previous post IDs before you run this, but that worked for me. I used the same sort of query on my comments as well.

Topic Closed

This topic has been closed to new replies.

About this Topic