Hello.
> | eps4.inmail | repair | warning | Can't change size of indexfile, error: 27 As of MySQL 4.0.2, there is a USE_FRM mode for REPAIR TABLE. Use it if the .MYI index file's header is corrupted. See: http://dev.mysql.com/doc/mysql/en/repair-table.html Dirk Vleugels <[EMAIL PROTECTED]> wrote: > 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 > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
