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'
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