mysql 主从错误
时间：2010-05-06 来源：badb0y
Last_Error: Error 'Can't create database
1. MySQL > stop slave;
2.SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; start slave; http://forums.mysql.com/read.php?26,292647,293054#msg-293054 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
1. MySQL > stop slave;
2.SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; start slave; http://forums.mysql.com/read.php?26,292647,293054#msg-293054 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
相关阅读 更多 +
排行榜 更多 +
