So, after working on a script that imports tons of data from another API, and doing lots of testing, all new posts I make have a post ID above 10,000,000.

Thing is, now that I'm done, all my test data is gone, and my last "real" post has the ID 88.

Is there a method to "reset" my post ID's, so that the next one I make has the ID 89? I know that there's no real need to do this, but I plan on maintaining this site for many years and it'll be annoying.

Worst case, I can just reinstall and export/import.

  • why? ID is just a uniqque id and the value has no meaning – Mark Kaplun Aug 14 '18 at 15:16
  • ... and don't do development on production servers – Mark Kaplun Aug 14 '18 at 15:18
  • It's not on production. It's on a development server, who's database will soon be cloned into production. – Brian Aug 14 '18 at 15:23
  • which make it exactlu like production – Mark Kaplun Aug 14 '18 at 16:45
  • Yes... my dev environment is exactly like my production environment. It makes debugging quite simple. As far as I know, most developers prefer to have similar prod/dev instances ;) – Brian Aug 14 '18 at 20:06

I also happened to me once, I only had like 10 real post, so what I did was to go to phpMyAdmin, make sure your that on my wp_posts and wp_posts_meta tables are only information about the 10 real posts IDs, from the mysite/wp-admin/export.php I exported all the posts (10 of them), I run the following SQL query on phpMyAdmin.

DELETE FROM wp_posts;
DELETE FROM wp_post_meta;

TRUNCATE TABLE wp_post_meta;

And finally, I import again the 10 posts, after that the ID was bad to normally, mine was only around 10000 tho, but it should work nonetheless.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.