mysql同步中断报错

时间：2008-11-26 来源：xueleixu

[ERROR] Slave: Query caused different errors on master and slave. Error on master: 'Table '%-.64s' is marked as crashed and should be repaired' (1194), Error on slave: 'no error' (0). Default database: 'house'. Query: 'update sell set esta='2' where esta='1' and `expiretime`!='' and `expiretime`<1224795661', Error_code: 0
出现上面的报错信息，主要是表坏了，需要把表修复一下，人后在slave start ，就可以了！！！ mysql slave 出现复制错误“Could not parse relay log event entry 可以执行下面的语句： CHANGE MASTER TO MASTER_LOG_FILE=<Relay_Master_Log_File>, MASTER_LOG_POS=<Exec_Master_Log_Pos>

相关阅读更多 +