reset web id

[ustoopia]

I was wondering if it is somehow possible to reset the web id's in ispconfig 3.

Reason I'm curious is because I've removed all webs on my ispconfig machine and when I create a new web it will continue counting the id's while all the previous ones don't exist anymore.

[ustoopia]

I've been thinking about this and I thought this can perhaps be reset in the ispconfig database but I'm not sure where to look exactly. The only thing I could find so far is in:

dpispconfig > web_domain > domain_id

Is this correct? And if so, what can I do here (using phpmyadmin) to reset the web id's?

[till]

Is this correct? And if so, what can I do here (using phpmyadmin) to reset the web id's?

Yes, thats correct. You can reset the ID with phpmyadmin if you removed all sites and also depending records like FTP / shell users od these websites.

[ustoopia]

Originally Posted by till

Yes, thats correct. You can reset the ID with phpmyadmin if you removed all sites and also depending records like FTP / shell users od these websites.

After some trial and error I managed to reset the id's. First I kept trying to reset them by setting AUTO_INCREMENT to 0 but this didnt work. AUTO_INCREMENT has to be changed to 1 and then you will start with web id 1 when creating a new website.

Thanks for the answer Till

[Toucan]

Just remember, and correct me if I'm wrong anyone, you'll only get one chance at reseting the ids as once you have a production site you won't be able to easily get back to web1 as it's auto incrementation