从主数据库导数据到从数据库

FLUSH TABLES WITH READ LOCK;master
load data from master;
slave stop;
reset slave;
SHOW MASTER STATUS; 取得日志名和更新点。master
CHANGE MASTER TO MASTER_LOG_FILE='binary_log_name',MASTER_LOG_POS=4;

slave start;
UNLOCK TABLES;master