Plug in ID, how to reset

[neiljames54]

I am rebuilding my website 300+ articles with individual maps, I decided to start with a fresh 3.7.2 joomla version and use the same map id's. I have been copying and pasting the map name and co-ordinates from the old site to the new site and to keep things simple I have been using the same chronological order, this will allow me to keep the same plug in id when I transfer the articles over. Sadly I have managed at number 215 to break the chronological order and now my numbers are out of sync!!!.
I have tried to delete the wrong numbered map but that id used still counts and automatically moves to the next number, is there any way to go back pick up, and reset the the id to the number I need to keep my maps in the chronological number

[Jan]

Hi, this depends on your database. Mostly "autoincrement" fields are not restored when you empty the table only when you delete it and create newly. See e.g. phpMyAdmin:

Empty the table (TRUNCATE) or delete one row means, that autoincrement will be not reset
Delete the table (DROP) and create new means that autoincrement will start at 1 again.

Jan