[TYPO3-english] Best practice migrating mysql 4.1.x -> 5.0.x with mixed innodb myisam tables

[Götz Reinicke - IT-Koordinator]

Hey,

happy new year and I do have a question what might be the best way to
migrate some different databases to a new central server.

The question came up as I wanted to put our typo3 database on our
newer master/slave mysql installation.

We run red hat el 4 and 5 right now, so the source db is mysql 4.1.22
and the target is 5.0.77.

I did a mysqldump (--create-options --default-character-set=utf8 -K -e
--opt -q) on the source server and imported that dump on the new system,
but all innodb tabels are converted to myisam.

In the last time I focused on other topics than mysql, so may be
somewone can explain to me or give me a link to some compressed doku on
what happend and why?!

The other question is, what might be the best way to migrate the 'old'
database to a/the new system? This might be importand to, when switching
to myslq > 5.0

Dose the my.cnf options for innodb have to be identically?

Thanks a lot for any hint or suggestion!


	Best regards . Götz
-- 
Götz Reinicke
IT-Koordinator

Tel. +49 7141 969 420
Fax  +49 7141 969 55 420
E-Mail goetz.reinicke at filmakademie.de

Filmakademie Baden-Württemberg GmbH
Akademiehof 10
71638 Ludwigsburg
www.filmakademie.de

Eintragung Amtsgericht Stuttgart HRB 205016
Vorsitzende des Aufsichtsrats:
Prof. Dr. Claudia Hübner

Geschäftsführer:
Prof. Thomas Schadt