The recommended way to quickly check all tables is:
myisamchk --silent --fast /path/to/datadir/*/*.MYI isamchk --silent /path/to/datadir/*/*.ISM
that's from the mysql manual, sectio 4.4.6 Using myisamchk for Table Maintenance and Crash Recovery
That'll work, BUT you'd better make sure you keep the server from accessing the tables at the same time.
mysqlcheck can check tables, and there is no risk of interaction with the server. Also, mysqlcheck can be run from a remote host, whereas myisamchk/isamchk must be run on the server host.
----- Original Message ----- From: "Sigurd Urdahl" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 29, 2003 3:26 PM Subject: Check table wildcard syntax?
> Linpro A/S http://www.linpro.no/
I need to do CHECK TABLE on a lot of tables (actually on all tables in several databases), and hoped to do something like
mysql> CHECK TABLE reports.*
which ddn't work. The only thing that seems to work is using cut'n'paste (or some scritpting) to get a comme seperated list. Is there really no "smart" way of doing this?
version 3.23.49-log
regards, -sig
-- Sigurd Urdahl [EMAIL PROTECTED] Systemkonsulent og sånt Systems consultant and such
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
