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