Update starting post ID?

  • Resolved supernovia

    (@supernovia)


    16 years, 3 months ago

    Hi,

    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?

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

    (@supernovia)

    (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)

    Thread Starter supernovia

    (@supernovia)

    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.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Update starting post ID?’ is closed to new replies.