[horde] Migrating Database from horde3 to horde5

[Vilius Sumskas/LNK]

> Hello everybody,
> Thanks for all your input!
> 
> The first thing i tried out now, after your feedback, was running
> horde-db-migrate from the command line, and i think, that did the trick.
> The first run took quite a while (~60minutes), the second one 5 min...
> but with the third run, the DB was converted. When i tried this in the
> Webinterface, i clicked the "Update-Button" at least 20times, but always
> got the same error message
> 
> SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "rampage_types" does
> not exist LINE 1: SELECT type_id, type_name FROM "rampage_types" WHERE
> type_na..
> 
> 
> So what i did now:
> 1. dump the original database and convert the encoding to utf8 with 
iconv
> 2. then dump the database back in a new database being already utf8
> 3. then do the text to bytea conversion
> 4. and finally run the horde-db-migrate script from command line three
> times.
> 
> i just did the whole proces a second time and it went smoothly!

If you have converted your database from latin1 (or whatever) to UTF-8, 
you still need to find a way to convert serialized data in the database. 
At least some Horde preferences comes to my mind.

-- 
   Vilius