webX counter

Discussion in 'General' started by bin-online, Mar 13, 2006.

  1. bin-online

    bin-online New Member

    i have a problem, i make for test 3 webs, then I delete them an want now to make a new web1 with mail user web1p1 for an customer that he can get his old web number. But he gets the number web4. Where is the file or db record. to set it back to 1. Its very importent for me that my customers can get her old web number!

    Thank you
  2. falko

    falko Super Moderator Howtoforge Staff

    This is set by the MySQL database. It has an autoincrement column, that's why the IDs get counted up. You cannot change that.
  3. Sheridan

    Sheridan New Member

    It's possible, but i wouldn't recommend it as you can really mess up the database. ;)

    Use "ALTER TABLE <tablename> AUTO_INCREMENT = <value_to_start_with>" to set the auto_increment start value.

    See the mysql documentation for further details and examples:

    Don't forget to make a backup. :cool:


Share This Page