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, 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]