- 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. This is applies to any Roundcube version shipped with Plesk, or to any other custom Roundcube versions.
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 for Roundcube versions shipped with Plesk:
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 to 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
dump_<domain>.sqlfiles contain the following warning instead of SQL queries:
This (2015111100) is not the Roundcube version for which I was designed. See README.txt for details.
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.shadowmysql -uadmin roundcubemail