MySQL 主从同步错误解决
1、出现错误提示、
Slave I/O: error connecting to master 'backup@192.168.1.x:3306' - retry-time: 60 retries: 86400, Error_code: 1045
解决方法:
从服务器上删除掉所有的二进制日志文件,所在路径为/usr/local/mysql/data/http://www.doczj.com/doc/7bb06f1a227916888486d769.html
包括一个数据目录下的http://www.doczj.com/doc/7bb06f1a227916888486d769.html文件和hostname-relay-bin开头的文件。
http://www.doczj.com/doc/7bb06f1a227916888486d769.html::记录了Mysql主服务器上的日志文件和记录位置、连接的密码。
2、出现错误提示
Error reading packet from server: File '/home/mysql/mysqlLog/log.000001' not found (Errcode: 2) ( server_errno=29)
解决方案:
由于主服务器运行了一段时间,产生了二进制文件,而slave是从log.000001开始读取的,删除主机二进制文件,包括log.index文件。
3、错误提示如下
Error 'Duplicate entry '1' for key 1' on query. Default database: 'movivi1'. Query: 'INSERT INTO `v1vid0_user_samename` VALUES(null,1,'123','11','4545','123')'
Error 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-' at line 1' on query. Default database: 'club'. Query: 'INSERT INTO club.point_process ( GIVEID, GETID, POINT, CREATETIME, DEMO ) VALUES ( 0, 4971112, 5, '2010-12-19 16:29:28',-'
1 row in set (0.00 sec)
Mysql > Slave status\G;
显示:Slave_SQL_Running 为NO
解决方法:
Mysql > stop slave;