主服务器：

grant replication slave on *.* to 'root_replication'@'192.168.0.174' identified by 'root';

my.ini

log_bin=master_binary_log

server_id=1

replicate_do_db=kcml

// 锁住更新

flush tables with read lock;

// 获取 master_binary_log.000001 日志文件及偏移量

show master status;

导出数据

// 解锁更新

unlock tables;

从服务器：

导入数据

my.ini

server_id=2

slave-skip-errors=1062,1053,1146

change master to master_host='192.168.0.200',master_user='root_replication',  master_password='root', master_port=3306, master_log_file='master_binary_log.000001', master_log_pos=3274;

start slave;