[horde] Migrating user data from an old horde instance to a new installation

[Christian Schoepplein]

Hi,

On Fr, Mär 03, 2017 at 04:56:43 +0200, Vilius Sumskas/LNK wrote:
>"horde" <horde-bounces at lists.horde.org> wrote on 2017.03.03 16:48:06:
>> I have a damn old horde installation which has to be migrated to a 
>> current setup.
>> 
>> Old installation:
>> 
>>   * Gollem: H3 (1.0.2)
>>   * Horde: 3.1.4
>>   * Imp: H3 (4.1.4)
>>   * Ingo: H3 (1.1.3)
>>   * Kronolith: H3 (2.1.4)
>>   * Turba: H3 (2.1.5)
>> 
>> New setup:
>> 
>>   * Horde: 5.2.13
>>   * Content: 2.0.5
>>   * Gollem: H5 (3.0.10)
>>   * Imp: H5 (6.2.17)
>>   * Ingo: H5 (3.2.13)
>>   * Kronolith: H5 (4.2.19)
>>   * Nag: H5 (4.2.13)
>>   * Timeobjects: 2.1.3
>>   * Turba: H5 (4.2.18)
>> 
>> Migrating and adapting the config from the old to the new system causes 
>> me no trouble, but I am not able to migrate all the userspecific data 
>> stored in the mysql db backend.
>> 
>> for that reason I see two possebilities now:
>> 
>> 1. Try again to migrate the database from the old horde setup to the new 
>
>>    installation. Because I have no idea what went wrong during the 
>>    first try, it is very likely that I will run into the same issues 
>>    again :-(.
>> 2. Start the new installation with an empty database which will be OK, 
>>    if I at least can migrate the addressbook entries from the old to 
>>    the new installation. What steps are necessary to do this? Would it 
>>    also be possible to export the adressbook entries into e.g. vCards, 
>>    csv files or whatever and import them into the new system via a 
>>    script or so?
>> 
>> Any help or hints how to migrate the adresses would be great!
>
>Without telling us what exactly went wrong (steps you did, errors, 
>screenshots, etc.) I'm afraid we won't be able to help much.

I understand that I'd need to provide more information, but doing a 
manual upgrade for horde and all application with all upgrades for the 
DB again, will take hours :-(. So first let me explain in general what 
steps I performed to get out if I did the right thing...

First of all I upgraded the horde framework to the latest 3.x version 
step by step for every patchlevel. The same I did for every application. 
I applyed the database patches and followed the steps mensioned in the 
doc/UPGRADING file.

When I was at the latest patchlevel for horde 3.x and all applications 
working with this horde version, I dumped the database, changed the 
table charset from ISO-8859-1 to UTF8 and the table engine from MyISAM 
to InnoDB.

In the next step I created a new installation with horde and the 
applications I need via pear to have a setup with the latest horde and 
applications versions and a current database setup. Then I replaced the 
database of this new setup with the dump from the old setup, so I had an 
old database but a current setup regarding to the framework and the 
apps.

In the next step I ran the horde-db-migrate script to update the old 
database schema to the current version.

This were the steps I performed to upgrade my old system, I hope they 
were right :-).

I again could do the database migration and provide the logfile, if this 
would help, and ofcourse I can provide the sql errors I get in the log 
after the upgrade. But first of all it would be interesting to know if 
I followed the right way during I upgraded the system...

Kind regards,

  Christian

-- 
Christian Schoepplein

Landeshauptstadt Muenchen
Referat fuer Bildung und Sport
Zentrum fuer Informationstechnologie im Bildungsbereich (ZIB)
- Netze und Servermanagement

Postanschrift:                          Bueroanschrift:

Landeshauptstadt Muenchen               Landeshauptstadt Muenchen
Referat fuer Bildung und Sport          Referat fuer Bildung und Sport
Postfach                                Bayerstr. 28 (Raum 5.326)

80313 Muenchen                          80335 Muenchen

T: +49 (0)89 233-87623
E: c.schoepplein (at) musin.de
I: http://www.zib.musin.de

Elektronische Kommunikation mit der Landeshauptstadt Muenchen, siehe: 
http://www.muenchen.de/ekomm

Bitte denken Sie an die Umwelt, bevor Sie diese E-Mail ausdrucken. Pro 
Blatt sparen Sie durchschnittlich 15g Holz, 260ml Wasser, 0,05kWh Strom 
und 5g CO2.