Migrate mail users from one ispconfig3 server to another

[grungy]

I want to migrate mail users for a SINGLE domain from one ispconfig3 server to another. I do not want to do it manually by entering all mail users one by one. What is the best way of doing this?

If I use mysqldump and import mail_users to the new server will ispconfig create the accounts in /var/vmail/ ?

I used mysqldump like this:

mysqldump -u root -p dbispconfig mail_user
--where="sys_groupid='30'";

and I will only use the line that begins with

-- -- Dumping data for table `mail_user` -- -- WHERE:  sys_groupid='30'

Do I have to manually change the IDs? maybe use some replace option since mysqldump supports it?

[vogelor]

Originally Posted by grungy

If I use mysqldump and import mail_users to the new server will ispconfig create the accounts in /var/vmail/ ?

NO! this is because of the way, the servers share their data. if you dump the new data to this table, all the other servers didn't know anything about this change and so they WILL NOT do anything.

You can only add them manually or with the remote-api but NEVER direct. You will destroy your Installation

[grungy]

What if I create the users manually and then import the data?

I would change the user ids etc....

[vogelor]

Originally Posted by grungy

What if I create the users manually and then import the data?

I would change the user ids etc....

Sorry, i would like to help you, but there is NO WAY.
This is because of the "ISPConfig 3 multiserver - kernel"

[grungy]

vogelor,

Why is the multiserver kernel thing relevant to this discussion? My two servers are not linked - they are not in a multiserver environment.

[vogelor]

not 100% true, but to understand:

INTERALL we have:
1) the master -> the interface where you do your setup
2) n clients -> doing everything, the interface told them

this means, you have only ONE hardware, but INTERN you have 1 master (interface) and 1 client doing the email setup.

if you change the tables by your own, you only change the data, the interface displays BUT you do not tell the client to do the setup, this can only be done by the interface! if you edit the interface, the new data is stored in the tables AND the client gets a "command" to do what you change.

again, this is not 100% the truth, but "real enough" to understand the problem in short...

Olli