Migrating a large MySQL database from one server to another? One of these three options might fit your needs:
- Use rsync to synchronize the data folder of MySQL
- Use mysqldump and mysql commands
- Master-Slave replication (also with mysqldump and mysql)
In this article I will go over the characteristics of each approach, sum up the advantages and disadvantages and give a step-by-step example for tranfserring a MySQL database using the mysqldump and mysql commands approach.