From: Date: February 20 2001 1:13pm
Subject: Re: Error 127
List-Archive: http://lists.mysql.com/mysql/65877
Message-Id: <v04220800b6b80ad39ae6@[66.44.69.224]>
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1" ; format="flowed"
Content-Transfer-Encoding: quoted-printable

>Hello everybody,
>
>About two hours ago I had a system crash and one of my MySQL databases was
>extensively used at the same time. When the system went back up, the=20
>table (the
>table has 37000 rows) that was used at the time of the crash started=20
>to give me
>the error
>: Got error: 1030: Got error 127 from table handler when retrieving data fr=
om
>server
>
>What does that mean? Can I somehow fix it - a second database has started t=
o
>give similar error codes as well.
>
>Thanks,
>Lauri V=E4in

Sir, you have a corrupted table. Use isamchk to repair it. If isamchk=20
can't repair it, you will have to restore it from your backup. See=20
the online manual for information on isamchk, or see Paul Debois's=20
book for a more detailed discussion of table repair.

Bob Hall

Know thyself? Absurd direction!
Bubbles bear no introspection.     -Khushhal Khan Khatak