Resetting post ID number

  • Not a major problem, more of a mild annoyance.

    Basocally I’ve been putting up a few test posts on the site while designing the layout and all that. I’ve now deleted these test posts and am ready to start posting properly, but the post ID number is now 14 because of all the test posts I made before.

    Is there any way to reset this number back to 1 again? Or should I just leave it?

Viewing 2 replies - 1 through 2 (of 2 total)

  • In most cases it’s smarter to leave it, but if it’s bugging you, you can change them through the database by manually editing the ID for records in the posts table.

    To reset where ID-ing starts from you’ll have to change your posts table’s auto-increment value. The SQL query for that is:

    ALTER TABLE wp_posts AUTO_INCREMENT=X;

    The X should be the value for the next available ID. Edit the posts table prefix if not using the default.

    Note: Always back up (export) your database before making changes to it.

    Thread Starter kaa

    (@kaa)

    Ah right, I guess I’ll leave it then ??

    Thanks for the help!

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