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 web CMS 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.reini...@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
smime.p7s
Description: S/MIME Cryptographic Signature
