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
(text/plain)