1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Horde identities didn't migrate

Discussion in 'Plesk for Linux - 8.x and Older' started by garan, Aug 5, 2007.

  1. garan

    garan Guest

    0
     
    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
     
Loading...