Hi,
I came across a strange problem in MySQL. Some of the tables are getting
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.
Is there anything I can do to avoid such errors to occur in future ?
Don't these errors make MySQL unreliable ?
plz revert back if someone faced the same problem.
Thanks
Akash Agarwal
Senior Member Technical Staff,
Intersolutions Pvt Ltd,
NOIDA, INDIA
(www.lotusinterworks.com)
(www.alacre.com)
---------------------------------------------------------------------
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
