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

Reply via email to