where is WEBID auto-increment in db ?

Discussion in 'Installation/Configuration' started by arnaud, May 9, 2006.

  1. arnaud

    arnaud New Member


    I'm searching where is stored the WEBID auto-increment number which is used in the auto prefix user.
    I whant to reset this number or init it to a fixed number because I will migrate some accounts from another server and i whant keep the old username.
    Can you help me ?
    Thank you
  2. falko

    falko Super Moderator Howtoforge Staff

    The auto-increment is in the table definition of the isp_isp_web table in the ISPConfig database. I wouldn't change anything there, you'll most probably mess up the database!
  3. arnaud

    arnaud New Member

    Thank you.
    But, I want to migrate some accounts from another ISPConfig to a new ISPConfig (on another server) and I want to give the same login on the new server that on the old server.
    old server:
    new server:
    But I don't know how to make this except create fake accounts (web1,2,3,4,5,6,7,8,9,10,11,12,13,14 ; use web15; 16,17,18,19 ; use web20) etc...
    thank you by advance,

  4. falko

    falko Super Moderator Howtoforge Staff

    You can try to change the table definition, but it's at your own risk.
  5. ctroyp

    ctroyp New Member HowtoForge Supporter

    This should do the trick, but as Falko has mentioned, do this at your own risk:
    alter table isp_isp_web, auto_increment=[I]starting number[/I]

Share This Page