List:General Discussion« Previous MessageNext Message »
From:Matthew McNicol Date:July 29 2003 2:53pm
Subject:Re: Check table wildcard syntax?
View as plain text  

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
>
>

Thread
Check table wildcard syntax?Sigurd Urdahl29 Jul
  • Re: Check table wildcard syntax?Matthew McNicol29 Jul
    • Re: Check table wildcard syntax?Sigurd Urdahl29 Jul
      • Re: Check table wildcard syntax?Sergei Golubchik29 Jul
    • Re: Check table wildcard syntax?Paul DuBois30 Jul
  • Re: Check table wildcard syntax?Matthew McNicol29 Jul
  • Re: Check table wildcard syntax?Paul DuBois30 Jul