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
I'm always tinkering with new ideas and building interesting things. From AI-powered tools to micro-SaaS products, these are the projects currently keeping me up at night. Each one solves a specific problem I've encountered or explores an emerging technology I'm excited about.
🤖 PMPrompt
I recently launched PMPrompt, a curated collection of AI prompts for product managers. The goal is simple - help PMs save time and be more effective by leveraging AI in their daily workflow. Read more about this project in my blog post about building PMPrompt or try the AI-Powered PRD Generator.
📊 SurveySnaps
I recently launched SurveySnaps, a platform that makes collecting location-based feedback dead simple using QR codes. The goal is straightforward - help businesses gather real-time feedback from specific locations without the complexity of traditional survey tools. Read more about this project in my blog post about building SurveySnaps.
🏗️ 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. One of the tools I am developing is a JSONL Validator to ensure the integrity and structure of JSONL data. 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