Jan Walraven
DevOps



Menu
Categories:
Posted on

The following command dumps the database with replication position. You can import this file on the slave server. The replication will replicate all changes after this dump automatically because of the replication position in the dumpfile.


mysqldump -h 127.0.0.1 -p –master-data -a databasetosync > databasetosync.sql