List:General Discussion« Previous MessageNext Message »
From:Fournier Jocelyn [Presence-PC] Date:July 13 2001 11:04pm
Subject:Urgent problem : recovering a table with no MYI file ?
View as plain text  
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

Thread
Urgent problem : recovering a table with no MYI file ?Fournier Jocelyn [Presence-PC]14 Jul
  • Re: Urgent problem : recovering a table with no MYI file ?Jeremy Zawodny14 Jul
Re[6]: Urgent problem : recovering a table with no MYI file ?Werner Stuerenburg14 Jul