There might not be anything wrong at all.  I believe you may often get 
this error if clients are currently using the tables.  That's the way it 
was with the older 'myisamchk' program (for MySQL 3.23.xx), because it 
worked directly on the data files rather than going through the database 
server.  'mysqlcheck' (for MySQL 4.0.x+), I think, does go through the 
server, but you still might get this error if you're not locking tables 
before doing the check.

 From the mysql client, you can try locking all the tables you want to 
check, querying 'CHECK TABLE tablename', then release your locks.

Anyway... 'REPAIR TABLE tablename' is the way to go if you have this 
problem, but I bet it's probably nothing...

Here's some table maintainence/recover info for 'myisamchk'.  
http://dev.mysql.com/doc/mysql/en/Table_maintenance.html  I believe 
there are links there to other recovery topics related to mysql.

regards,
alex

Brock wrote:

>Look at the mysql docs for the "REPAIR TABLE tablenmae" query. There are
>some other options you can give it to have it rebuild indexes and such.
>
>Sorry, link not handy.
>
>--Brock
>
>On 2004.10.21.08.59, Miles Beck wrote:
>| 
>| 
>| WARNING: mysqlcheck has found corrupt tables
>| 
>| The table is listed and then this is displayed.
>| 
>| "warning: 13 clients are using or haven't closed the table properly"
>| 
>| This occurs for 19 tables in a database I have running.
>| 
>| How do tables get corrupted and what should I do to fix this?
>| 
>| Thanks
>| 
>| -------------------------------------------------
>| FastQ Communications 
>| Providing Innovative Internet Solutions Since 1993
>| 
>| ---------------------------------------------------
>| PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
>| To subscribe, unsubscribe, or to change  you mail settings:
>| http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>---------------------------------------------------
>PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
>To subscribe, unsubscribe, or to change  you mail settings:
>http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>
>  
>

---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change  you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss