Dear All
If I have thousand tables, how can I know which one is corrupted
quickly?
thanks
from Peter (cmk128 (AT) hotmail (DOT) com)

Hi Peter,

make a mysqldump of all tables?

regards,

Toni

On 11/05/11 07:40, peter wrote:
If you know that one is corrupt, the error log may be enough to point
you to it. If it is an index running wild, look at the table maintenance
commands (ANALYZE TABLE, OPTIMIZE TABLE, CHECK TABLE). The symptoms of
an index running wild are being unable to insert a new record or
"sudden" foreign key constraint errors for perfectly valid data.

Best regards
--
Willem Bogaerts

Application smith
Kratz B.V.
http://www.kratz.nl/

If you want this fast and without creating a file use something like:

mysqldump --user=username --password=secure --all-databases > /dev/null

If you have standard innodb engine running and don't want to disturb other db-operations use:
--single-transaction

regards,

Toni

peter <cmk128 (AT) gmail (DOT) com> wrote:

Corrupted tables are 99.9% a MyISAM problem. If you suspect that a
significant number of your tables is corrupt (i.e. after a crash)
then the best solution would be to stop MySQL (to not start it in
the first place) and run

myisamchk --fast --force $DATADIR/*/*.MYI

this will check all MyISAM tables and repair those that are corrupt.
You want to set the respective options either on the command line or
in my.cnf to have myisamchk make good use of your machines memory.

-> http://dev.mysql.com/doc/refman/5.1/en/myisamchk.html


If the server is already running, then CHECK TABLE is your friend.
In order to check all tables, use the mysqlcheck client tool (which
in turn will run CHECK TABLE and REPAIR TABLE on individual tables).

-> http://dev.mysql.com/doc/refman/5.1/en/mysqlcheck.html


Yet another possibility is to enable automatic recovery for MyISAM
tables. When a (suspectedly) corrupted table is opened, it will
then be checked and repaired automatically.

-> http://dev.mysql.com/doc/refman/5.1/...myisam-recover


XL