WordPress.org

Ready to get started?Download WordPress

Forums

Resetting post ID number (3 posts)

  1. kaa
    Member
    Posted 9 years ago #

    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?

  2. Kafkaesqui

    Posted 9 years ago #

    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.

  3. kaa
    Member
    Posted 9 years ago #

    Ah right, I guess I'll leave it then :P

    Thanks for the help!

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags