Despite of various features included within Mysql server, there are few situations where you might face corruption related issues. To overcome such situations, Mysql provides you in-built repair utilities but in other case, mysql repair is considered as the best option to get rid of errors like mysql clients are using or haven't closed the table properly.

Consider a practical scenario where you are trying to run myisamchk command in order to check a table in Mysql 5.0 but instead of got the following error message on screen:

"Clients are using or haven't closed the table properly."

Cause:

The above behavior is encountered due to improper closing of MYISAM index file which can be due to a number of reasons like:

• When the MyISAM table is being copied without making use of Lock or flush table command
• When myisamchk command modified a table while it is being used by Mysql server
• During the time, data are being written into a table, mysql crashed suddenly

Any of the above reasons lead to data corruption and then you need to repair the mysql databases.

Solution:

Carry out the below solutions to fix mysql clients are using or haven't closed the table properly error:

• Make use of CHECK TABLE command: It will scan and check the consistency of mysql table. Use this command in the following manner:
CHECK TABLE tablename;
• Then after use REPAIR TABLE command to resolve the corruption issues existing in mysql table as well as also fixes MyISAM index corruption in the following manner:
REPAIR TABLE tablename;

But if the above repair command does not prove to be the useful one, then the best would be to use mysql repair tool in case of unavailability of an updated backup that easily repairs the corrupt databases without taking much of your time and effort.