I need to move a single mySQL database from one server to another. This will be a one time move of some fairly large tables (message board system).
If anyone has any good migration strategies, I would love to hear them. Options we're considering are:
1) SQL script to read/write information from one server to the other
2) backing up all files and copying them to the new server (I'm not sure where the files reside though)
3) doing a dump and reload of the database (seems to run overly slow for our needs).
Additionally, if anyone has a clue where the option in the mySQL config files is to specify WHERE the database files below, I would love to hear it. The server we've moving the database to has two sets of disk in, one being RAID. And we'd like to make sure the database is running on the faster RAID area.
Thanks for helping a newbie.
If anyone has any good migration strategies, I would love to hear them. Options we're considering are:
1) SQL script to read/write information from one server to the other
2) backing up all files and copying them to the new server (I'm not sure where the files reside though)
3) doing a dump and reload of the database (seems to run overly slow for our needs).
Additionally, if anyone has a clue where the option in the mySQL config files is to specify WHERE the database files below, I would love to hear it. The server we've moving the database to has two sets of disk in, one being RAID. And we'd like to make sure the database is running on the faster RAID area.
Thanks for helping a newbie.