List:MySQL on Win32« Previous MessageNext Message »
From:Sam Carleton Date:June 14 2009 7:51pm
Subject:Moving MySql server to a new machine.
View as plain text  
I am upgrading my server and need to move over MySql server.

From what I have been able to gather if I simply shutdown the old
server, moved all the files and kept them in the exact same place, I
should be able to start things up on the new machine.  Is that
correct?  The only extra task would be to register MySql as a service.

A couple of things thought...

1: I would like to move both the location of the binaries and the data.
2: I would also like to upgrade the old server (5.0.45) to the latest
version, 5.1.35.

With respect to #1: This is simply a matter of changing the paths at
installation of 5.1.35, which I have done successfully.
With respect to #2: Can I simply shutdown both servers and copy the
datadir files from the old 5.0.45 to the datadir of the new 5.1.35?
There is also a innodb_data_home_dir, do I need to move those files
too?

Sam
Thread
Moving MySql server to a new machine.Sam Carleton14 Jun 2009
  • Re: Moving MySql server to a new machine.Guy Gordon17 Jun 2009