Re: upgrading from 4.1 to 5.4

2009-10-02 Thread Joerg Bruehe
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'

RE: upgrading from 4.1 to 5.4

2009-10-01 Thread Gavin Towey
Using mysqldump and loading directly into 5.4 *might* work, but you should never do any of this on your production system without testing. Get another box, start with 4.1 and do the upgrade on a test server -- even test your queries as there a few incompatible changes between 4 and 5. One you