> Is there a common cause to the following problem?:
>
> mysql> select parent_referral from referral;
> ERROR 1030: Got error 127 from table handler

chris@mirage:~$ perror 127
Error code 127:  Unknown error: 127
127 = Record-file is crashed
chris@mirage:~$

> Our system is running 3.22.23b and we're only having the problem with
> the largest table in our database (it's got about 75k records in it
> with 13 fields total file size of the ISD is about 65 megs)

Since you're using 3.22, you can use isamchk to repair the table. Check
http://www.mysql.com/doc/R/e/Repair.html, most of the information there is
the same except you can't use REPAIR TABLE with 3.22, and you have to
replace myisamchk with isamchk.


---------------------------------------------------------------------
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

Reply via email to