Hi Jenifer, You can use mysqlcheck to confirm any corruption and also to fix it. See http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html
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 http://dev.mysql.com/doc/refman/5.0/en/table-maintenance-sql.html These are equally applicable at version 4.1 regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -----Original Message----- From: Subscriptions [mailto:[EMAIL PROTECTED] Sent: Monday, 12 December 2005 3:01 AM To: mysql@lists.mysql.com Subject: How can you tell if a table is corrupted? Hi all, 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 out? Jenifer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
