> corrupted. The most common error messages which I encountered are : "Can't > open file: 'tablename.MYD'. (errno: 145)" and "Got error 127 from table > handler". > I rectified it by shutting down the MySQL Server and using "myisamchk" > with the options -r and sometimes -o.
145 = Table was marked as crashed and should be repaired > Is there anything I can do to avoid such errors to occur in future ? Yes. Stop your machine from crashing :) > Don't these errors make MySQL unreliable ? Not at all, considering the nature of the problem. --------------------------------------------------------------------- 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
