cacti-Incorrect file format 'syslog' ... LOCK TABLES

备份数据库时报错:Incorrect file format 'syslog' when using LOCK TABLES

查看syslog.MYI文件大小为0,判断是索引损坏

 

进入mysql执行:

REPAIR TABLE cacti.syslog USE_FRM;

 

syslog_incoming表也有问题

Incorrect file format 'syslog_incoming' when using LOCK TABLES

 

继续执行:

REPAIR TABLE cacti.syslog_incoming USE_FRM;

标签: cacti

发表评论: