bigbrother etc # mysqlcheck -u mysar -p -h localhost mysar traffic
Enter password:
mysar.traffic
warning : Table is marked as crashed and last repair failed
error : Found key at page -1 that points to record outside datafile
error : Corrupt
mysql> CHECK TABLE traffic;
+---------------+-------+----------+-------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------+-------+----------+-------------------------------------------------------------+
| mysar.traffic | check | warning | Table is marked as crashed and last repair failed |
| mysar.traffic | check | warning | Size of indexfile is: 285001728 Should be: 1024 |
| mysar.traffic | check | warning | Size of datafile is: 1635298600 Should be: 1635292192 |
| mysar.traffic | check | error | Record-count is not ok; is 13327256 Should be: 0 |
| mysar.traffic | check | warning | Found 13327757 parts Should be: 0 parts |
| mysar.traffic | check | error | Corrupt |
+---------------+-------+----------+-------------------------------------------------------------+
6 rows in set (1 min 57.22 sec)
mysql>