id14
Verified User
- Joined
- Aug 3, 2019
- Messages
- 26
I have a customer who had domain-old.com but wanted to change that to domain-new.com.
The customer wanted to use the same mail accounts and save the mail from domain-old.com to domain-new.com.
I used the rename domain function in DirectAdmin and the mail accounts got renamed from @domain-old.com to @domain-new.com and all the mail is present but the problem I encounter is with the contacts and contacts groups in Roundcube they are gone for @domain-new.com
I took a look at the Roundcube database and saw that the contacts and groups are still present but under the old ID. For example the contacts are under ID 150 but that is a @domain-old.com the @domain-new.com has ID 300 with no contacts. I tried to modify ID 150 to @domain-new.com but obviously that doesn’t work because it would create a duplicate entry.
How can I move the contacts and contacts groups from ID 150 to ID 300 , I suppose with a database query but I am not that familiar with database queries. Has anybody a idea how I can do this on a efficient way?
Any suggestions are appreciated.
The customer wanted to use the same mail accounts and save the mail from domain-old.com to domain-new.com.
I used the rename domain function in DirectAdmin and the mail accounts got renamed from @domain-old.com to @domain-new.com and all the mail is present but the problem I encounter is with the contacts and contacts groups in Roundcube they are gone for @domain-new.com
I took a look at the Roundcube database and saw that the contacts and groups are still present but under the old ID. For example the contacts are under ID 150 but that is a @domain-old.com the @domain-new.com has ID 300 with no contacts. I tried to modify ID 150 to @domain-new.com but obviously that doesn’t work because it would create a duplicate entry.
How can I move the contacts and contacts groups from ID 150 to ID 300 , I suppose with a database query but I am not that familiar with database queries. Has anybody a idea how I can do this on a efficient way?
Any suggestions are appreciated.