Last_Error: Error 'Can't create database
1. MySQL > stop slave;
2.SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; start slave;
Last_SQL_Error: Error 'Duplicate entry '4' for key 'PRIMARY''
1、从 stop slave;
2、主 flush tables with read lock;
show master status;
3、从change master to master_host='192.168.1.174',master_user='root',master_password='google',master_port=3306,master_log_file='mysql-bin.000012',master_log_pos=93016;
start slave;
4、主 unlock tables;
http://blog.chinaunix.net/u/249/showart.php?id=2228913
阅读(934) | 评论(0) | 转发(0) |
