Doubt for delete all members on community and restart count ID members

[Marco Junior]

Hi how are you everyone ?

I have an small doubt, Recently I remove my complete member list on my community, but the new members start with ID high example:   ID for first member is == 1 right ?

On old list have 632 members, I need restart ID for start == 2,3,4,5,6,7,8.....

Is possible release this ? without reinstall complete community ?

[Ryan Ashbrook]

No, it is not possible to reset the ID at this time. You would need to completely reinstall the community.

[Adriano Faria]

If you have only one member and this member is ID = 1, you can run the following query to reset:

ALTER TABLE core_members AUTO_INCREMENT = 2;

You would need to make sure you have NO other data related to member IDs in your entire database, table per table, that’s why a reinstall is recommended.

Use at your own risk and make a backup of your database before if you’re willing to try it.

[Marco Junior]

I understand, then I will make a new db and transfer only data of topics !

Is better and more security.

Thanks ! 

[Miss_B]

4 hours ago, Marco Junior said:

Recently I remove my complete member list on my community

Did you make a backup of your database beforehand?

Edited January 27, 2023 by Miss_B

[Marc]

20 hours ago, Marco Junior said:

I understand, then I will make a new db and transfer only data of topics !

Is better and more security.

Thanks ! 

You should import using the converters if you are doing it in this manner

It is worth noting, the IDs really should be treated as such. They are nothing more than something to identify the user programmatically. So it shouldn't really matter what that number is visually.