本地环境,MySQL复制报错,上去看看:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
原来是磁盘满了,删掉一些,进去
Slave_IO_Running: No
Slave_SQL_Running: Yes
还是不行,因为刚才删了一些binlog。
slave stop;
flush logs;
CHANGE MASTER TO MASTER_LOG_FILE='xxxxxx.xxxx',MASTER_LOG_POS=xxxx; (从master那边查询)
start slave;
两边都这么处理一下,正常。
参考URL如下:
http://www.jb51.net/article/27906.htm