Home / server / Questions / 422507
Accepted
Nick M.
Asked: 2012-08-30 06:22:44 +0800 CST

mysql Incorrect Information in File: (corrupt) error

  • 772

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
mysql

2 Answers

  1. Best Answer
    Incorrect information in file:    './cacti/poller_item.frm'

    .frm file stores the table format. Try this:

    • Stop MySQL
    • Take the backup of poller_item.frm, poller_item.MYD, poller_item.MYI
    • Drop the poller_item table
    • Start MySQL
    • Recreate poller_item table by using CREATE TABLE statement in cacti.sql (uses the corresponding version that you're running)
    • Stop MySQL
    • Copy the poller_item.MYD, poller_item.MYI into the datadir
    • Start MySQL again
    • 3

  2. take backup first and then try try MYISAMCHK(1):

    myisamchk --recover tbl
myisamchk --save-recover tbl
    • 0