Address book, - how to migrate "Address book" to other Roundcube installation

[next4ideas]

Hello fellas,

we have 02 servers, both with centon6 and plesk 11, its easy to migrate our clients using Plesk manager transfer,
i migrate web contente, emails accounts, configs, etc
only a thing that i cant migrate is address book of RC,

how can i migrate the address book of each email account of my customers?
thanks!

[SKaero]

Back up the RoundCube database on one and restore it the the other server.

[next4ideas]

i got it.

but think that we have 2 servers with clients in there (both),

so if overwrite db on it i will loose "address book" from existing customer in the new server.

what solution does we have in this situatuation

[SKaero]

Ah I see the problem. You'll need to re-number the user accounts and attached fields as there entered into the new database so there are no conflicts.

[next4ideas]

Hi Skaero,

i did not understand very well, could you be more detail?

how i re-number user account? is inside of phpmyadmin, into a table?
i suppose to do this for each customer?

thank you

[SKaero]

All of the unique ids in one of the databases (pick the smaller one) will need to be renumber so they don't conflict with the entries in the database your joining them to. You'll need to code a script to do it, try google "mysql merge two databases together" to find examples of scripts used.

[next4ideas]

Thank you, i will do that and let you know!

[macareno]

Hello,

The roundcube webmail is a cool software that now we have in Plesk Panel.

It is a painful task to migrate a hosting from a Plesk Panel to another Plesk Panel because Parallels does not provide any support to export Roundcube webmail configuration (users, identities, contacts, groups...) .

I made a research to automatically export Roundcube configuration and I didn't find anything useful.

Fortunatelly my developer colleague listened my complaints and he wrote a script to help me with the migrations.

export-roundcube-sql.php

Exports Roundcube webmail configuration (users, identities, contacts, groups...) for a given domain:

https://github.com/JaimeObregon/export-roundcube-sql

You can find more comments here

[primitivo]

Hi, if someone want to use the script mentioned by macareno (https://github.com/JaimeObregon/export-roundcube-sql), I can confirm that it working fine on Roundcube 1.2.3 (version in table system: 2015111100).
Thanks macareno and Jaime Obregon, very usefull script.

[Abhijit Roy]

please give a proper idea how to move address book from one server to another by using mysql, my upgraded version is 1.6