Hi!
On Jul 14, Dan wrote:
> Hi all.
>
> I have a MyISAM table ( MySQL-4.0.13) that will get truncated every
> month, and around 1,000,000 records imported into it. The import process
> consists of a 'load data infile' operation, followed by some updates to
> extract data and dump it somewhere
John,
Saturday, August 10, 2002, 4:32:37 AM, you wrote:
JP> I keep getting a problem with our MySQL database, I know what error 127 is
JP> ('Record-file is crashed / Network is down'), it keeps occuring on several
JP> tables that are frequently accessed by our website.
JP> I can fix the problem
able to
proceed.
Hope that helps you.
Dave Lake
>From: "Diehl, Jeffrey" <[EMAIL PROTECTED]>
>To: "'Chris Bolt '" <[EMAIL PROTECTED]>, "'[EMAIL PROTECTED] '"
><[EMAIL PROTECTED]>
>Subject: RE: Error 127 from table
> I'm using 3.22.27 and am getting an error when I submit queries.
>
> I do a select * from table where...
>
> And it gives me:
>
> ERROR 1030: Got error 127 from table handler
chris@entropy:~$ perror 127
Error code 127: Unknown error 127
127 = Record-file is crashed
Run isamchk -r on the ta
> Go error 127 from table handler.. fixed itself in about 10 minutes..
> don't know what this is or why it happened.. anyone know?
>
> It happened while doing an update SQL command to a table.
> I'm not even sure what it means.. can't find any error codes.
Try running perror 127
---
