Hi!
I don't do DBA work, so my info may be incomplete: monem mysql wrote: > Hello > > > I have to upgrade many mysql databases from mysql 4 and 4.1 to 5.4 with a > large size 2.7 TB > > [[...]] > > > The official method takes too much time. But I've read that we can use '*dump > and reload'* to upgrade directly to 5.1, will it work with 5.4? I am not aware of any significant difference between 5.1 and 5.4 in the MyISAM area, so there are good chances that experiences with 5.1 are applicable to 5.4 as well. (InnoDB would be a different matter.) > > Also the tables contain many charset? Will they be altered? Going from 4.0 or 4.1 to 5.1 and up brings you all the changes in charset / collation handling, but there should be no additional difference between 5.1 and 5.4 AFAIK. > > [[...]] > > Are there any better solution and any precaution to take? I second Gavin's advice: Do a test migration and check the most important ones of your applications. Pay special attention to "strange" characters outside the ASCII range. HTH, Jörg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com Sun Microsystems GmbH, Komturstraße 18a, D-12099 Berlin Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Wolf Frenkel Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
