Bug #44778 Add schema name in output of mysqlcheck
Submitted: 11 May 2009 9:36 Modified: 29 Jun 2011 10:51
Reporter: Susanne Ebrecht Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: General Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[11 May 2009 9:36] Susanne Ebrecht
Description:
$ mysql_upgrade --all-databases
...
mysqlcheck will start and will throw tons of errors like this:

error : Table upgrade required. Please do "REPAIR TABLE `foo`" to fix it!
error : Table upgrade required. Please do "REPAIR TABLE `bar`" to fix it!

It would be really helpful when the schema name would be given here too.

Something like:

error : Table upgrade required. Please do "REPAIR TABLE `db1.foo`" to fix it!
error : Table upgrade required. Please do "REPAIR TABLE `db2.bar`" to fix it!

How to repeat:
Just run mysql_upgrade --all-database for upgrade from 5.0 to 5.1.

Suggested fix:
Add schema names to error message output
[29 Jun 2011 10:51] MySQL Verification Team
duplicate of bug #47208