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