Hi,
I'm administrating a machine which has just badly crashed, and a MYI file has disappeared
for one table.
Is this possible to repair this table ?
BTW, REPAIR TABLE in mysql report a wrong message :
mysql> REPAIR TABLE threadhardwarefr1;
+------------------------------+--------+----------+-----------------------------------------------------+
| Table | Op | Msg_type | Msg_text
|
+------------------------------+--------+----------+-----------------------------------------------------+
| Hardwarefr.threadhardwarefr1 | repair | error | Can't find file:
'threadhardwarefr1.MYD' (errno: 2) |
+------------------------------+--------+----------+-----------------------------------------------------+
1 row in set (0.00 sec)
MYD file is here, but MYI is missing...
Thank you !
Jocelyn Fournier
Presence-PC