Hello.
REPAIR TABLE ... USE_FRM helps in difficult cases. See: http://dev.mysql.com/doc/mysql/en/repair-table.html Per Jessen <[EMAIL PROTECTED]> wrote: > All, > I've got a table with about 25mill rows that was victim of a crash recently. > (power-failure). > I've been trying to recover it, but I'm not making much progress. > >>From the most recent attempts: > > myisamchk --safe-recover --force <table> > - recovering (with keycache) MyISAM-table '<table>' > Data records: 21622679 > 49800008000 > 7256000 > 10627000 > myisamchk: error: 126 for record at pos 1589881104 > MyISAM-table '<table>' is not fixed because of errors > > myisamchk -r --force --tmpdir=/data2/tmp <table> > - recovering (with sort) MyISAM-table '<table>' > Data records: 12876899 > - Fixing index 1 > - Fixing index 2 > - Fixing index 3 > Key 3 - Found wrong stored record at 0 > MyISAM-table '<table>' is not fixed because of errors > > > Where do I go from here? I've got a backup of the table, but I'm not sure > what sort of state it > is in. > > -- 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]