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
----- Original Message -----
From: "Sigurd Urdahl" <sigurdur@stripped>
To: <mysql@stripped>
Sent: Tuesday, July 29, 2003 3:26 PM
Subject: Check table wildcard syntax?
>
> 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 sigurdur@stripped
> Systemkonsulent og sånt Systems consultant and such
> Linpro A/S http://www.linpro.no/
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
>
>
