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]