reset web id

Discussion in 'Installation/Configuration' started by ustoopia, Jul 29, 2010.

  1. ustoopia

    ustoopia Member

    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.
  2. ustoopia

    ustoopia Member

    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?
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
  4. ustoopia

    ustoopia Member

    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 :)
  5. Toucan

    Toucan Member

    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

Share This Page