Now, I when I do a desc on data table, I get the error
ERROR 1016 (HY000): Can't open file: 'data.MYI' (errorno: 144).
As I recall I ran:
optimize data;
The Optimize command did not complete the error as I recall was /var
filesystem full.
Running the following commands:
ls data.*
data.MYD
Hmmm. Doesn't look pretty, Raymond! You've got 4.6GB of data and
just 1K of indexes now.
Step ZERO - make a backup copy of the files you have NOW, in case any
repair operations you try make things worse.
On the bright side, your data file (.MYD) should sitll be intact -
it's just the index
Thank you,
raymond
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 13, 2006 18:07
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: I ran of disk space running optimize on table Now I can
not open data.MYI
Hmmm. Doesn't look pretty