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.
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_posts;
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.
