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
Urgent problem : recovering a table with no MYI file ?
Fournier Jocelyn [Presence-PC] Fri, 13 Jul 2001 16:20:03 -0700
- Re: Urgent problem : recovering a table wit... Fournier Jocelyn [Presence-PC]
- Re: Urgent problem : recovering a tabl... Jeremy Zawodny
- Re[6]: Urgent problem : recovering a t... Werner Stuerenburg