----- Original Message ----- From: "Martin Mokrejs" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, April 05, 2002 10:41 PM Subject: Table crash!
> Don't do this when the table is in the cache! > > The correct way (open two xterms and do commands in this order): > > mysql> flush tables; > mysql> lock table repository write; > > $ myisamchk -f -d -v repository.MYI # this will tell you the status of > the table based on the index file > I've used myisamchk while mysql server was not running. I've shut it down first and then tryed to fix it with myisamchk. But I will try all those other options you have so kindly mentioned in your reply. THNX! Will tell you about the results. Regards, Aleš Perme --------------------------------------------------------------------- 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