List:General Discussion« Previous MessageNext Message »
From:Jeremy Zawodny Date:July 14 2001 10:04am
Subject:Re: Urgent problem : recovering a table with no MYI file ?
View as plain text  
On Sat, Jul 14, 2001 at 01:04:41AM +0200, Fournier Jocelyn [Presence-PC] wrote:
> 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?

Try to touch the file (to create an empty one), and see if that is
sufficient to get MySQL doing what it should.  Don't know if it will
help, but you never know.

Jeremy
-- 
Jeremy D. Zawodny, <jzawodn@stripped>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878   Fax: (408) 349-5454   Cell: (408) 685-5936 <-- NEW

MySQL 3.23.29: up 28 days, processed 213,616,674 queries (88/sec. avg)
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