Akash,
Sunday, October 27, 2002, 10:49:55 AM, you wrote:
A> I came across a strange problem in MySQL. Some of the tables are getting
A> corrupted. The most common error messages which I encountered are : "Can't
A> open file: 'tablename.MYD'. (errno: 145)" and "Got error 127 from table
A> handler".
A> I rectified it by shutting down the MySQL Server and using "myisamchk"
A> with the options -r and sometimes -o.
A> Is there anything I can do to avoid such errors to occur in future ?
A> Don't these errors make MySQL unreliable ?
If your tables becomes corrupted so often, you should fine the source
of the problem. I think the following section of the manual may help
you:
http://www.mysql.com/doc/en/Corrupted_MyISAM_tables.html
http://www.mysql.com/doc/en/Reproduceable_test_case.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.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
