You can use mysqlcheck to confirm any corruption and also to fix it. See
or you can also run statements from the mysql client such as CHECK
TABLE, REPAIR and ANALYZE etc.
References to this can be found at
These are equally applicable at version 4.1
HP Managed Services
148 Frome Street,
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
From: Subscriptions [mailto:subscriptions@stripped]
Sent: Monday, 12 December 2005 3:01 AM
Subject: How can you tell if a table is corrupted?
Say, is there a way to tell if a table has been corrupted? We're having
some weird things happening and the only thing I can think of is
possible corruption of a table, but is there anything you can do to find