G
garan
Guest
I've been migrating some Plesk 8.1 accounts to a separate 8.2 server and found that the horde identities haven't come across. This could be because there were issues with the migration stumbling on one of the mail accounts but I'm not sure.
Had to be solved as rollback wasn't an option for such a minor detail. So to export and import identities for the domain mydomain.co.uk:
1) Run 'mysql -u admin -p' on the old box
2) use horde
3) select * into outfile "preferenceexport" from horde_prefs where pref_uid like "%mydomain.co.uk" and pref_name="identities";
4) This created a file called preferenceexport in /var/lib/mysql/horde/
5) scp that file across to /var/lib/mysql/horde/ on the new server
6) Run 'mysql -u admin -p' on the new server
7) use horde
8) load data infile "preferenceexport" into table horde_prefs;
Bingo.
Garan
Had to be solved as rollback wasn't an option for such a minor detail. So to export and import identities for the domain mydomain.co.uk:
1) Run 'mysql -u admin -p' on the old box
2) use horde
3) select * into outfile "preferenceexport" from horde_prefs where pref_uid like "%mydomain.co.uk" and pref_name="identities";
4) This created a file called preferenceexport in /var/lib/mysql/horde/
5) scp that file across to /var/lib/mysql/horde/ on the new server
6) Run 'mysql -u admin -p' on the new server
7) use horde
8) load data infile "preferenceexport" into table horde_prefs;
Bingo.
Garan