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 immediatelly and the error has dissapeared. I assume simply doing a check is a read only operation so how is this possible if the data file is not changing? I went as far as doing a diff on tables before and after the check to make sure nothing changes and it seems to be read only. I have also made absolutelly sure the database is down so nothing is writing to the files. Has anyone experienced this before? thanks, Mark. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
