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

[Bjoern Pedersen]

Am 10.01.2011 10:48, schrieb 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.
> 

Does the dump contain CREATE TABLE xxx (.... ) ENGINE=InnoDB ?
Are all directories for InnoDB correctly configured? Otherwise ymsql
fill use myISAM tables as a fallback.

Björn