export/import of mailuser using db

Discussion in 'Installation/Configuration' started by kardac, Jun 27, 2010.

  1. kardac

    kardac New Member

    Hi.

    I have installed a new ISPconfig 3 server to replace my old one. Due to different reasons i dont want to keep anything of the old settings except the mailsetting.

    If i want to export all old mailaccounts with e-mails is it enough to export the mail_ tables and import them to the new servers dbispconfig?

    Something i need to think about before i do this (except backup)?


    Thanx for a great product!
     
    Last edited: Jun 27, 2010
  2. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    This is possible for the email part. Export and import the email tables and then copy the file structure in /var/vmail from the old to the new server. If any of the email accounts are assigned to a client, you will have to export and import the client, sys_user and sys_group tables too.

    Just as a note for other readers of this thread. This export works only for the mail users, it will not work for websites or DNS records.
     
  3. kardac

    kardac New Member

    Thanx for the answer. The e-mail accounts is assigned to a client, if i dont import the client, sys_user and sys_group tables, wont the e-mail accounts show up in ISPconfig?

    I have already created the client and assigned a site and isntalled an CMS there so i risk overwrite the new data if i import the client I guess :)


    Br,
    Kardac
     
  4. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    They will probably show up for the admin but will trow errors when you edit them.

    The only other thing that you can do is to edit the sys_userid, sys_groupid odf all records that you import to match a existing user and group in the new datbase (e.g. userid 1 and groupid 1 for the admin user).
     

Share This Page