Migrate saved settings for Horde in Plesk 8/9

Migrating settings that are saved in Horde such as your contact book, folders or aliases is not supported by Plesk 8 as of version 8.6 nor will it be supported in any future versions of Plesk as horde has been out of development for some time. However there is a way to manually migrate the data.

To migrate your Horde configuration to your new server, you will need to go to the server where the information that you need to migrate is. Once there, you need to login via shell / SSH. Once logged in, we need to backup 3 databases;

kronolith_events

kronolith_storage

Horde Mysql database

*MAKE SURE YOU MAKE BACKUPS BEFORE YOU DO THIS*

To do this, we need to backup the tables as such;

~# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` horde --tables kronolith_events > kronolith_events.dump ~# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` horde --tables kronolith_storage > kronolith_storage.dump

Then we need to backup the Horde database;

~# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` horde > horde.old.dump

Now that we have the files, you will need to move them to the new server, either by ftp, wget, scp or however you move your files between your servers.

Now on the new server, make sure you make a backup of these files incase restore process fails;

~# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` horde > horde.new.dump ~# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` horde --tables kronolith_events > kronolith_events.dump~# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` horde --tables kronolith_storage > kronolith_storage.dump

Put these files in a different directory to make sure you do not get confused.

Now we can start to restore the old data by doing the following;

~# mysql -uadmin -p`cat /etc/psa/.psa.shadow` horde < kronolith_events.dump~# mysql -uadmin -p`cat /etc/psa/.psa.shadow` horde < kronolith_storage.dump

Before you restore the Horde database, you will want to remove the existing one first and then recreate it;

~# mysql -uadmin -p`cat /etc/psa/.psa.shadow` -e"drop database horde"~# mysql -uadmin -p`cat /etc/psa/.psa.shadow` -e"create database horde"

Then restore the original Horde database;

~# mysql -uadmin -p`cat /etc/psa/.psa.shadow` horde < horde.old.dump

Once you do this and restart Horde/Exim, you will have all of your contacts and settings migrated and ready to use on the new server.