Carter,
Monday, May 20, 2002, 4:31:07 PM, you wrote:
C> Can anyone shed some light on this? Have found that others have
C> run into this (via Google) but no resolution and no hits at
C> www.mysql.com.
C> A count(*) query returns fine but trying to select the rows
C> fails (see log snippet below).
C> Regards,
C> Bob
C> mysql> select count(*) from event where sid=9 and cid > 694725;
C> +----------+
C> | count(*) |
C> +----------+
C> | 4925 |
C> +----------+
C> 1 row in set (0.01 sec)
C> mysql> select * from event where sid=9 and cid > 694725 LIMIT 0, 100000;
C> ERROR 1030: Got error 127 from table handler
$ perror 127
Error code 127: Unknown error 127
127 = Record-file is crashed
You can try to repair your table using myisamchk
or REPAIR TABLE statement.
Read info about how to repair table at:
http://www.mysql.com/doc/R/e/Repair.html
About myisamchk at:
http://www.mysql.com/doc/T/a/Table_maintenance.html
and about REPAIR TABLE at:
http://www.mysql.com/doc/R/E/REPAIR_TABLE.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
