逐梦论坛's Archiver

shillan 发表于 2018-7-19 11:17

MySQL Got error 28 from storage engine (1030) Slave...checksum的解决方法

[b]现象:[/b]MySQL主从数据库同步时报错:
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Slave can not handle replication events with the checksum that master is configured to log; the first event 'mysql-bin.000011' at 120, the last event read from './mysql-bin.000011' at 120, the last byte read from './mysql-bin.000011' at 120.'
[b]原因:[/b]数据库版本不一致导致。
[b]解决:[/b]
解决办法1:
数据库换成一致版本。
解决办法2:
在master的my.cnf或my.ini中设置[code]binlog_checksum=none[/code]

页: [1]

Powered by Discuz! Archiver 7.2  © 2001-2009 Comsenz Inc.