WordPress Reset AUTO_INCREMENT ID In Posts
July 22, 2014
wordpressI've been testing a massive migration from a proprietary CMS to WordPress (using my WordPress C# client).
After about 20 different tests my post IDs in the WordPress MySQL database got out of control. I'd create 3,000 posts in one swoop and turn around and delete them while testing. This made my IDs something like 31,341 after day. This isn't a huge deal but it's annoying to me.
Note: If you already have created posts / pages and attached them to categories and then change the post id then they will no longer be related properly.
A quick google search will likely lead you to How to reset AUTO_INCREMENT in MySQL on Stackoverflow. However this won't work if you are running on the InnoDB engine. In my case I could just mass delete all the post with a SQL statement. If you have content and run the following commands bad stuff will happen.
I'd only use this if you don't care about dropping all your posts! USE ONLY IN LOCAL/DEV ENVIRONMENT
Active Projects
Here are some of the projects I am currently working on. Some are side projects, some are client projects, and some are just for fun. I like to build things and I like to share what I learn along the way. If you have any questions about any of these projects, feel free to reach out.
🏗️ JSONL Tools
I am working on a set of tools to help me work with JSONL. JSONL is a simple format for working with JSON data. I am working on a set of tools to help me work with JSONL data. I will use these tools to help me work with my own data as well as help me build my own APIs. Read more about this project in my blog post about building JSONL Tools.
🤖 Make Storytime
Personalized children's stories generated by AI. This is an app I am building with my kids.
📠 Fax Online
Yea, I know. But there is a long tail for everything and believe it or not there was an underserved market for people that need to send a fax online. Some people (like me!) just need to send a one time fax.
Read more about this micro Saas project in a blog post about building an online fax service.
🥑 Free URL Indexer
Free URL Indexer is a free tool to help you index your backlinks and get them into Google faster. It's a simple tool that I built to help me with my own SEO efforts and I decided to share it with the world. It's a free tool and I don't even ask for your email address. Just paste in your URL and click the button.
👉 See all projects