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]