之前binlog_format使用默认 备份binlog,是可以还原的
/usr/local/mysql/bin/mysqlbinlog --set-charset=utf8 mysql-bin.000844 > 1.sql
现在binlog_format设置为mixed以后,还原出错,是什么原因呢 ?/usr/local/mysql/bin/mysqlbinlog --set-charset=utf8 mysql-bin.000844 > 1.sql
ERROR: Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 84, event_type: 19
Could not read entry at offset 10559:Error in log format or read error
改如何解决呢
/usr/local/mysql/bin/mysqlbinlog --set-charset=utf8 mysql-bin.000844 > 1.sql
现在binlog_format设置为mixed以后,还原出错,是什么原因呢 ?/usr/local/mysql/bin/mysqlbinlog --set-charset=utf8 mysql-bin.000844 > 1.sql
ERROR: Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 84, event_type: 19
Could not read entry at offset 10559:Error in log format or read error
改如何解决呢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货