Could not find first log file name in binary log index file

  1. 首先停止从库同步;
    slave stop;
  2. 主库中清空日志:
    flush logs;
  1. 查看主库状态,主要查看日志文件和位置:
    show master status;
  1. 回到从库中,执行命令,使日志文件和位置对应主库:
    CHANGE MASTER TO MASTER_LOG_FILE=·log-bin.000005·,MASTER_LOG_POS=107;

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

  1. 最后,启动从库:
    slave start;
    成功解决!
#

关闭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