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 file (.MYI) that's hosed. At a high level, you're
going to want to rebuild that index file. How - is a little trickier.
See http://dev.mysql.com/doc/refman/5.0/en/repair.html
I expect you'll want to look at the section titled "Stage 3: Difficult
repair" because the first part of your index file is in fact
destroyed.
Good luck!
Dan
On 7/13/06, Jacob, Raymond A Jr <[EMAIL PROTECTED]> wrote:
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 data.MYI data.frm
acid# ls -last snort/data.*
2 -rw-rw---- 1 mysql mysql 1024 Jul 12 14:23 data.MYI
4543712 -rw-rw---- 1 mysql mysql 4650467248 Jul 12 14:09 data.MYD
10 -rw-rw---- 1 mysql mysql 8632 Jun 28 20:54 data.frm
Is there anything I can do to get this table back?
r/Raymond
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
