Re: isamchk and myisamchk inconsistently report errors

2001-01-24 Thread Tibor Simko
Hello > I assume simply doing a check is a read only operation so how is > this possible if the data file is not changing? The manual says: "in some case CHECK TABLE will change the table! This happens if the table is marked as 'corrupted' or 'not closed properly' but CHECK TABLE didn't find an

isamchk and myisamchk inconsistently report errors

2001-01-24 Thread Mark Maunder
I have had the following problem with both mysql 3.22 (using isamchk) and 3.23 (using myisamchk). I use either isamchk table.ISM or isamchk -e table.ISM. The utility reports a miscellaneous error (error: Record at: 20224201 Can't find key for index: 2 for example). I run the check again imm