what's the result of SHOW CREATE TABLE games
?? I'd drop the indexes on the games table, and then run repair tables, and then put the indexes back in. Worth a shot. -Sheeri On 3/29/06, Sander Smeenk <[EMAIL PROTECTED]> wrote: > Quoting [EMAIL PROTECTED] ([EMAIL PROTECTED]): > > > Have you tried the following myisamchk option: > > --extend-check, -e > > Yup. But that won't even work at ALL: > > # myisamchk -e games.MYI > Checking MyISAM file: games.MYI > Data records: 10644 Deleted blocks: 0 > - check file-size > - check record delete-chain > - check key delete-chain > - check index reference > - check data record references index: 1 > - check data record references index: 2 > myisamchk: error: Key in wrong position at page 715776 > - check records and index references > myisamchk: error: Keypointers and record positions doesn't match > MyISAM-table 'games.MYI' is corrupted > Fix it using switch "-r" or "-o" > > Strange, huh! > > -- > | Don't hate yourself in the morning -- sleep till noon. > | 1024D/08CEC94D - 34B3 3314 B146 E13C 70C8 9BDB D463 7E41 08CE C94D > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
