- Plesk for Linux
Is it possible to migrate Roundcube address books?
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:
The top-ranked suggestions are likely to be included in the next versions of Plesk.
Also, the following workaround could be used:
export-roundcube-sql.phpPHP script from the following GitHub repository: https://github.com/JaimeObregon/export-roundcube-sql .
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>.sqlfiles 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
dump_<domain>.sqlfiles to the target server.
Import the transferred files into the
# cat dump*.sql | MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin roundcubemail