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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] > 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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
