mysql主从同步出错解决方法

2016/12/29 mysql
           Last_SQL_Error: Error 'Duplicate entry '100-appsearch' for key 'PRIMARY'' on query. Default database: 'shouji'. Query: 'INSERT INTO `shouji_configs` (`stype`,`mainkey`,`val`,`add_time`)  VALUES(100,'appsearch','https://downpack.baidu.com/appsearch_AndroidPhone_v7.8.14.8(1.0.64.58)_1012271b.apk',unix_timestamp())'

解决方法: Mysql > stop slave; Mysql > set global sql_slave_skip_counter =1 ; Mysql > start slave;


Search

    Table of Contents