[imp] OFF TOPIC: how to migrate mysql data

[Miroslaw Jaworski]

* Bruno Negrao (imp-bnegrao at engepel.com.br) [030212 14:53] wrote:
> Don't need anymore, I got it:
> 
> from the machine owning the original table:
> 
> mysqldump --opt horde --password=xxxxx | mysql -u horde --password=yyyy --host=somehost horde

Default mysqldump settings can result in corrupted data on the other
side - no complete inserts are requested ( target table structure can be 
different - table may have additional fields for example ), also mysqldump's
default "create database" and "create table" statements can result in 
errors ( "cannot create database, database already exist", "cannot create
table..." or sth like it ).

Not knowing details about your installations ( horde/imp versions of
source/target installation ), whether horde_prefs structure has ever 
changed between versions ( although i've checked that in 1.2.7 there were
no horde_prefs, and if it's new in 2.x, table structure could be changed 
between let's say 2.0 and 2.1 ) i gave you the safe advice :)

Regards

M.

-- 
Miroslaw.Jaworski at gts.pl  ( Psyborg )  MJ102-RIPE  GTS Internet Partners SA
Servers Administration Department Manager