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?
mysqlcheck is a command line interface to the CHECK TABLE statement. If you invoke it like this, it will check all tables in the named database by figuring out the necessary CHECK TABLE statements and sending them to the server for you:
mysqlcheck db_name
Use "mysqlcheck --help" for more information about available options.
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/
-- 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]
