Bug #4448 wildcards for repair table command
Submitted: 8 Jul 2004 1:15 Modified: 25 Dec 2005 12:19
Reporter: steve haldane Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S4 (Feature request)
Version: OS:
Assigned to: CPU Architecture:Any

[8 Jul 2004 1:15] steve haldane
Wildcards would be great for this command (e.g. REPAIR TABLE <dbname>.*  or REPAIR DATABASE <dbname>) 

There's a certain database i manage who's tables periodically get corrupted. it'd be nice to be able to do that blind repair on all the tables without having to check each table individually.

How to repeat:
this isn't a bug. 

Suggested fix:
nothing to fix
[8 Jul 2004 1:26] Paul DuBois
You could do this with mysqlcheck --repair db_name.
mysqlcheck --repair is a command-line interface to
REPAIR TABLE.  It issues a SHOW TABLES statement
for the database, then issues a REPAIR TABLE statement
for each of them.
[25 Dec 2005 12:19] Valeriy Kravchuk
Thank you for a feature request. As Paul already explained you, there is alternative way to get the same results, so I do not think there is any reason to implement the feature you requested.