Author Topic: Address book, - how to migrate "Address book" to other Roundcube installation  (Read 14627 times)

Offline next4ideas

  • Jr. Member
  • **
  • Posts: 47
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!


Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Back up the RoundCube database on one and restore it the the other server.

Offline next4ideas

  • Jr. Member
  • **
  • Posts: 47
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



Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
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.

Offline next4ideas

  • Jr. Member
  • **
  • Posts: 47
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

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
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.

Offline next4ideas

  • Jr. Member
  • **
  • Posts: 47
Thank you, i will do that and let you know!

Offline macareno

  • Newbie
  • *
  • Posts: 1
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
« Last Edit: August 26, 2014, 04:23:56 AM by macareno »

Offline primitivo

  • Newbie
  • *
  • Posts: 1
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.