I experience heavy trouble with a few tables and look for the cause for some time without finding out anything. I'm not ready to construct a bug report, though. Now I migrated these 3 tables from ISAM to MYISAM, so that I can CHECK TABLE from within the program and do a REPAIR TABLE when necessary. Am I correct in the assumption that I don't need a LOCK TABLE during CHECK TABLE, but otherwise during REPAIR TABLE? And if so, should I use a LOCK TABLE tbl_name WRITE? -- Herzlich Werner Stuerenburg _________________________________________________ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de --------------------------------------------------------------------- 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