Fixing Haywire Post Table Auto-Increment Value
For some odd reason, my auto-increment value for the post table is in the billions, instead of the millions where it belongs. While this isn't a problem right now, when it gets higher I can see it posing some real issues.
I'm trying to think of ways to get all the (16k) posts that are at or above that auto-increment value back down to where they belong, and hunting through the db for all the places postid might live sounds like a bad idea.
Is it possible to use impex to export the posts, so that I can reset the auto-increment value, and then import the posts again at their proper place?
|