How can you tell if a table is corrupted?

[Subscriptions]

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

Re: How can you tell if a table is corrupted?

[Eric Bergen]

If mysql detects corruption it will stop further access to the table
until you repair it. It is possible for corruption to happen where
mysql can't detect it. If you suspect corruption run a repair on the
table.

On 12/11/05, Subscriptions [EMAIL PROTECTED] wrote:
 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




--
Eric Bergen
[EMAIL PROTECTED]
http://www.ebergen.net

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: How can you tell if a table is corrupted?

[Logan, David (SST - Adelaide)]

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]