mysql Incorrect Information in File: (corrupt) error
- by Nick M.
I've recently suffered from a power outage on one of my monitoring servers at the office.
The result of that outage caused for some database tables to get corrupted.
I've successfully repaired 3-4 tables by using the "use_frm" option however there are still 3 that seem to be badly corrupted and are not responding to the mysql REPAIR command (with or without use_frm)
mysql> REPAIR TABLE poller_item;
+-------------------+--------+----------+---------------------------------------------- ------------+
| Table | Op | Msg_type | Msg_text |
+-------------------+--------+----------+------------------------------------------------- ---------+
| cacti.poller_item | repair | Error | Incorrect information in file: './cacti/poller_item.frm' |
| cacti.poller_item | repair | error | Corrupt |
+-------------------+--------+----------+------------------------------------------------- ---------+
In this scenario are there any other way to repair a table?
MySQL Version
mysql Ver 14.14 Distrib 5.1.49, for debian-linux-gnu (x86_64) using readline 6.1