Horde Calendar, Address Book and preferences are not migrated by Plesk Migrator

Symptoms

Domains have been migrated to Plesk using Plesk Migrator (Tools & Settings > Migration & Transfer Manager), but Calendar, Personal address book and Horde preferences were not migrated.

Cause

Migration of Horde Calendar, Address Book and preferences is not supported by Plesk Migrator: The Horde database format differs significantly from one version to another, which makes it impossible to automate this process.

Note: Horde will be deprecated in future Plesk releases.

Resolution

 Use the Import/Export feature of Horde webmail to migrate address books per email account.

1. On the source server, log in to Horde > go to Address Book tab > click Import/Export.

2. Click Export to save a contacts.csv file.

3. On the target Plesk server, log in to Horde > go to Address Book tab > click Import/Export.

4. Click Choose file > select contacts.csv and click Open > define options and click Next.

In order to migrate Horde Calendar, Address Book and preferences, migrate the Horde database. Use the commands below for manual migration.

Note: Already existing Horde data on the target Plesk server will be lost.

1. Dump the database on the source server:

   # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin horde > source_horde.sql

2. For security reasons, on the target (destination) server, back up the Horde database:

   # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin horde > target_horde.sql

3. Then, delete and recreate the database:

   # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin -e"drop database horde"
   # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin -e"create database horde"

4. Restore data from the source server:

   # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin horde < source_horde.sql