Roundcube Community Forum

News and Announcements => General Discussion => Topic started by: next4ideas on September 13, 2013, 09:46:24 AM

Title: Address book, - how to migrate "Address book" to other Roundcube installation
Post by: next4ideas on September 13, 2013, 09:46:24 AM

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!

Title: Re: Address book, - how to migrate "Address book" to other Roundcube installation
Post by: SKaero on September 13, 2013, 09:49:45 AM

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

Title: Re: Address book, - how to migrate "Address book" to other Roundcube installation
Post by: next4ideas on September 13, 2013, 10:17:45 AM

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

Title: Re: Address book, - how to migrate "Address book" to other Roundcube installation
Post by: SKaero on September 13, 2013, 10:32:51 AM

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.

Title: Re: Address book, - how to migrate "Address book" to other Roundcube installation
Post by: next4ideas on September 13, 2013, 11:14:10 AM

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

Title: Re: Address book, - how to migrate "Address book" to other Roundcube installation
Post by: SKaero on September 13, 2013, 11:37:25 AM

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.

Title: Re: Address book, - how to migrate "Address book" to other Roundcube installation
Post by: next4ideas on September 13, 2013, 06:09:41 PM

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

Title: Re: Address book, - how to migrate "Address book" to other Roundcube installation
Post by: macareno on August 26, 2014, 04:20:41 AM

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 (https://github.com/JaimeObregon/export-roundcube-sql)

You can find more comments here (http://forum.parallels.com/showthread.php?314955-Exports-Roundcube-webmail-configuration-(users-identities-contacts-groups-))

Title: Re: Address book, - how to migrate "Address book" to other Roundcube installation
Post by: primitivo on January 20, 2017, 06:27:53 AM

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.