WordPress Reset AUTO_INCREMENT ID In Posts

July 22, 2014

wordpress

I'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.

📦 Flow Export

Export Salesforce Flow to Miro to collaborate with your team. Read more about the launch of Flow Export on the Salesforce AppExchange.

🤖 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.

📱 Cloud Number

Cloud Number is a virtual phone app that helps you protect your privacy online. Use it to receive SMS online and keep your phone number private. It's also a great service for a freelancer or entrepreneur that wants to have a separate phone for their business for SMS and voicemail.

🥑 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