How to migrate Roundcube address books?

Created:

2016-12-18 06:42:15 UTC

Modified:

2017-08-08 13:22:01 UTC

0

Was this article helpful?


Have more questions?

Submit a request

How to migrate Roundcube address books?

Applicable to:

  • Plesk for Linux

Question

Is it possible to migrate Roundcube address books?

Answer

Roundcube does not provide any tools to import or export address books and other parameters, and its database format differs from version to version.

To make it possible to migrate Roundcube address books and other settings, provide a suggestion for new functionality on User Voice:

https://plesk.uservoice.com/forums/184549-feature-suggestions

The top-ranked suggestions are likely to be included in the next versions of Plesk.

Also, the following workaround could be used:

  1. Download export-roundcube-sql.php PHP script from the following GitHub repository: https://github.com/JaimeObregon/export-roundcube-sql .

  2. Execute the following commands on the source server dump Roundcube settings for all domains:

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin psa -sN -e"select name from domains;" > domains.txt
    # while read -r line1 || [[ -n "$line" ]]; do php export-roundcube-sql.php admin `cat /etc/psa/.psa.shadow` $line1 > "dump_$line1.sql"; done < domains.txt

    2.1. If the dump_<domain>.sql files contain the following warning: This (2015111100) is not the Roundcube version for which I was designed. See README.txt for details. instead of SQL queries, then change the max version to the version from the warning:

    # vi export-roundcube-sql.php
    ..........
    define('ROUNDCUBE_VERSION_MAX', '2015111100');
    ..........
  3. Transfer dump_<domain>.sql files to the target server.

  4. Import the transferred files into the roundcubemail database:

    # cat dump*.sql | MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin roundcubemail
    
Have more questions? Submit a request
Please sign in to leave a comment.