Could not find first log file name in binary log index file
CHANGE MASTER TO MASTER_LOG_FILE=·mysql-bin.000002·,MASTER_LOG_POS=1046342091
CHANGE MASTER TO MASTER_LOG_FILE=·mysql-bin.000002·,MASTER_LOG_POS=1046505953
关闭slave-skip-errors=all 查看是什么语句出错
show processlist 查看同步进程
快速同步方法,获取master的pos,备份到从导入,更改从库的pos,启动从即可快速导入(否则从要从头导入)
====================================================================
1677错误 cannot be converted from type ·int· to type ·varchar(100)·
数据类型不一至问题引起,
导出表结构,使用npp对比文件
======================================================================
http://www.cnblogs.com/polestar/p/5651870.html
6.查看事件内容
show binary logs; 查看binlog文件列表
show master status 当前正在写入的binlog文件
SHOW BINLOG EVENTS [IN ·log_name·] [FROM pos] [LIMIT [offset,] row_count] 查看指定binlog文件的内容语法:
1.SHOW BINLOG EVENTS IN ·mysql-bin.000005·
2.SHOW BINLOG EVENTS IN ·mysql-bin.000005· FROM 194 LIMIT limit 0,10
=============
SHOW RELAYLOG EVENTS [IN ·log_name·] [FROM pos] [LIMIT [offset,] row_count]
SHOW RELAYLOG EVENTS IN ·mariadb-relay-bin.000049· FROM 11216592 limit 0,10