Got error 127 from table handler

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
JayBird
Admin
Posts: 4524
Joined: Wed Aug 13, 2003 7:02 am
Location: York, UK
Contact:

Got error 127 from table handler

Post by JayBird »

Suddenly got this error on one of the tables in my database.

I did a repair using SQLyog. But now some of the last rows that were entered have gone.

I don't get the error now after the repair, but the information has gone for good.

What was the error, and what caused it?

How can i prevent it?

also, when i check my tables, i often get a message like "3 clients is using or hasn't closed the table properly".

How can i stop this from happening?

And finally, what the deal with the optimize and repair functions? when should i run them? how often?

Mark
Post Reply