Error 1030: error 127 (table handler)

Hello, approximatly twice a week I get Error 1030: error 127 (table handler) on one table. This table is around 2.3 GB, the indexfile around 2.2 GB. There are around 24.000.000 records in the table. I am running mysql 4.0.1-alpha on linux with 2.4.18 kernel. But I also got this error

Re: Error 1030: error 127 (table handler)

, approximatly twice a week I get Error 1030: error 127 (table handler) on one table. This table is around 2.3 GB, the indexfile around 2.2 GB. There are around 24.000.000 records in the table. I am running mysql 4.0.1-alpha on linux with 2.4.18 kernel. But I also got this error with older

Error 127: table handler

Hello, I'm now developping a Web application, based on MySQL. Since yesterday, I have the following error : "Got error 127 from table handler". Could you tell me what causes this problem, and (optionnaly :-) tell me how to repair that! I thank you by advance! Fred

Re: Error 127: table handler

mysqladmin shutdown myisamchk -o ./*.MYI myisamchk -r ./*.MYI (or isamchk if you are using the old isam tables) then restart mysql. - Original Message - From: "Frdric Bonjour" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 30, 2001 1:05 PM Subject: Error