Post Merged (destination) from dba.stackexchange.com/questions/5930/…
2 formatted text
source | link

You're going to need to take a downtime. It's going to take a while depending on what your network speed is. I'm going to assume your running MySQL on Linux/Unix. Here's the process I use:

  1. Stop the mysql daemon on the source host.
  2. Make a tmp folder on your target host to receive the files.
  3. Use screenscreen to make a shell session that will survive should your ssh get disconnected.
  4. Use rsyncrsync to transfer the files between hosts. Something like: rsync -avhP source user@targethost:/path/to/folder/rsync -avhP source user@targethost:/path/to/folder/
  5. Run your test cases to make sure you didn't lose anything in the transfer.

Then proceed as usual getting the local MySQL set up.

*Note: you can also use the -c parameter with rsync to add a checksum to the transfer, however this will be sloooow depending on CPU speed.

You're going to need to take a downtime. It's going to take a while depending on what your network speed is. I'm going to assume your running MySQL on Linux/Unix. Here's the process I use:

  1. Stop the mysql daemon on the source host.
  2. Make a tmp folder on your target host to receive the files.
  3. Use screen to make a shell session that will survive should your ssh get disconnected.
  4. Use rsync to transfer the files between hosts. Something like: rsync -avhP source user@targethost:/path/to/folder/
  5. Run your test cases to make sure you didn't lose anything in the transfer.

Then proceed as usual getting the local MySQL set up.

*Note: you can also use the -c parameter with rsync to add a checksum to the transfer, however this will be sloooow depending on CPU speed.

You're going to need to take a downtime. It's going to take a while depending on what your network speed is. I'm going to assume your running MySQL on Linux/Unix. Here's the process I use:

  1. Stop the mysql daemon on the source host.
  2. Make a tmp folder on your target host to receive the files.
  3. Use screen to make a shell session that will survive should your ssh get disconnected.
  4. Use rsync to transfer the files between hosts. Something like: rsync -avhP source user@targethost:/path/to/folder/
  5. Run your test cases to make sure you didn't lose anything in the transfer.

Then proceed as usual getting the local MySQL set up.

*Note: you can also use the -c parameter with rsync to add a checksum to the transfer, however this will be sloooow depending on CPU speed.

1
source | link

You're going to need to take a downtime. It's going to take a while depending on what your network speed is. I'm going to assume your running MySQL on Linux/Unix. Here's the process I use:

  1. Stop the mysql daemon on the source host.
  2. Make a tmp folder on your target host to receive the files.
  3. Use screen to make a shell session that will survive should your ssh get disconnected.
  4. Use rsync to transfer the files between hosts. Something like: rsync -avhP source user@targethost:/path/to/folder/
  5. Run your test cases to make sure you didn't lose anything in the transfer.

Then proceed as usual getting the local MySQL set up.

*Note: you can also use the -c parameter with rsync to add a checksum to the transfer, however this will be sloooow depending on CPU speed.