From: Date: June 17 2009 9:14pm
Subject: Re: Moving MySql server to a new machine.
List-Archive: http://lists.mysql.com/win32/19021
Message-Id: <nafi3556qne2cu65k9cbhpigeu69frg94p@4ax.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable

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). =20
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.