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
