Tag Archives: database

How to move a large MySQL database between servers?

Migrating a large MySQL database from one server to another? One of these three options might fit your needs:

  1. Use rsync to synchronize the data folder of MySQL
  2. Use mysqldump and mysql commands
  3. 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.

Continue reading