Dump full database with replication position for slave
Posted on February 23, 2012
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