Got error 127 from table handler
Posted: Mon Sep 22, 2003 8:41 am
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
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