Support » Fixing WordPress » How to renumber the posts

  • Resolved mahamaya3


    Hi all,

    I just inherited a WordPress blog which was originally used as a RSS aggregator for some time using a plugin wp-o-matic. There were so many posts from other bogs. So it simply inflated the number of posts.

    I removed all of them and started adding fresh posts. But alas! The post numbers (call it “Ids”) start from 2422!

    I do not like this. I want the numbers to start from 1.

    My friend tells me I should have deleted the old database and reinstalled anew which I failed to do. In the meanwhile I have added a few posts, images, pages…!

    Now please tell me how to change the posts id numbers. I searched through the forum wherein someone has remarked that it is a painful process. But I have a friend who can tinker with database. But he says he can do it if I get to know what are all the “tables” and elements to be changed.

    Please help me.

    Thanks you.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The post id numbers are assigned ‘automatically’ by MySQL because the ID field in wp_posts is auto incrementing.

    Just as a note, those ID numbers are used by posts, pages, attachments, revisions, and autosave, records, making it impossible (nearly) to manage IDs.

    Thanks, MichaelH

    Is it ok if the number gets bloated up to such figures. Supposing I become hyperactive and go on writing something. The number may shoot up to 5 figures. Will there be any problem with the database?

    Please enlighten me. I’m getting worries to look at numbers like 2435 and such!

    Will there be any problem with the database?

    No there shouldn’t be a problem.

    The post ID is stored in the database as an unsigned bigint(20). This has a maximum value of 18,446,744,073,709,551,615. Or, if you prefer, that’s eighteen quintillion, four hundred forty six quadrillion, seven hundred forty four trillion, seventy three billion, seven hundred nine million, five hundred fifty one thousand, six hundred fifteen posts before you really start to have a problem with the ID size.

    Of course, revisions and attachments and Pages take up post IDs too, but still… I wouldn’t worry about it too much. 😉

    oh! My God!
    Let my id’s grow, why bother!

    Thanks so much for the enlightenment.


Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘How to renumber the posts’ is closed to new replies.