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.

If you would like to see this feature in Plesk, please vote for this feature on Plesk UserVoice:

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

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