How do I reset the next entry_id to "1" after numerous test data imports?
How Do I?
I’ve completed lots of testing and data imports on a new site, so my entry_id values are now up into the 10,000’s. How can I reset the “next created” entry_id back to 1, now that I have deleted all my test entries?
I understand that in EE2 it could be done by editing the exp_channel_titles database table: ALTER TABLE exp_channel_titles AUTO_INCREMENT = 1
But I can’t see that data in this table on an EE5 install.
Solved it. In phpMyAdmin, I went to the exp_channel_titles table. I then clicked on the Operations tab. The AUTO_INCREMENT value for this table is displayed and is editable here.
I just reset the value back to what I needed, for the next newly-created Entry - in this case 277, as I wanted to keep all my existing entries up to ID 276. When I created a new Entry in EE, it was given the Entry ID of 277. The AUTO_INCREMENT value in the table is showing as 278.
Be careful when doing this. Remember that entries and other bits are tied to other tables and data within the database. So when changing it, you need to make sure the rest of the site matches!