Re: Moving MySql server to a new machine.

[Guy Gordon]

I'll let others answer your questions, but I advise you to split this into
separate tasks.   When something fails, it's *so* much easier to fix if you need
only examine the last step.

Move your data to the new server running the exact same MySQL version and config
(excepting only config changes necessary for new hardware).  
Verify function and data integrity.
Update to latest MySQL version.
Verify function and data integrity.
Tune the config to your new hardware (RAM, CPUs, drives, etc.)
Verify function and data integrity.

If you're serious about tuning for speed, add 'Benchmark' before & after each
step.

On Sun, 14 Jun 2009 13:51:33 -0400,  Sam Carleton <scarleton@stripped>
wrote:
<snips>
>I am upgrading my server and need to move over MySql server.
>2: I would also like to upgrade the old server (5.0.45) to the latest
>version, 5.1.35.