Dirk, Some suggestions. 1. can you still dump the table using mysqldump? Then you can import it again (with the mysql commandline client), creating a 'fresh' table.
2. make a backup of the index file (.MYI), then throw it away. MySQL will create a new index for you. HTH, Martijn > -----Original Message----- > From: news [mailto:[EMAIL PROTECTED] On Behalf Of Dirk Vleugels > Sent: dinsdag 12 juli 2005 19:37 > To: mysql@lists.mysql.com > Subject: repair table (error 27) > > Hi, > > the DB resided on a network appliance filer (happily for a > year). A nfs problem corrupted some tables, all got fixed but > this one: > > mysql> repair table inmail extended; > +-------------+--------+----------+--------------------------- > ----------------+ > | Table | Op | Msg_type | Msg_text > | > +-------------+--------+----------+--------------------------- > ----------------+ > | eps4.inmail | repair | warning | Can't change size of > indexfile, error: 27 | > | eps4.inmail | repair | error | 27 for record at pos > 9037492 | > | eps4.inmail | repair | error | 27 when trying to write > bufferts | > | eps4.inmail | repair | error | 27 when updateing keyfile > | > | eps4.inmail | repair | status | Operation failed > | > +-------------+--------+----------+--------------------------- > ----------------+ > 5 rows in set (11.03 sec) > > perror 27 says 'file to large', but the files in question are _small_: > > -rw-rw---- 1 mysql other 9037816 Jul 12 14:51 inmail.MYD > -rw-rw---- 1 mysql other 3377152 Jul 12 14:50 inmail.MYI > -rw-rw---- 1 mysql other 9358 Dec 8 2004 inmail.frm > > I tried myisamchk with different options, but no go. > > Any clues? Any way to recover the data (for re-import)? > > Regards, > Dirk > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- The information contained in this communication and any attachments is confidential and may be privileged, and is for the sole use of the intended recipient(s). Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please notify the sender immediately by replying to this message and destroy all copies of this message and any attachments. ASML is neither liable for the proper and complete transmission of the information contained in this communication, nor for any delay in its receipt. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
