Bug #59077 Output of mysql_upgrade from 5.0>5.1 and 5.1>5.5 should be more user friendly

• Submitted: 21 Dec 2010 4:22
• Modified: 23 Jul 2015 0:20
• Reporter: Roel Van de Paar
• Status: Closed
• Category: MySQL Server: General
• Severity: S3 (Non-critical)
• Version: 5.1,5.5
• OS: Any
• Assigned to: Assigned Account
• CPU Architecture: Any

[21 Dec 2010 4:22] Roel Van de Paar

Description:
c:\mysql558\bin>mysql_upgrade -uroot -P558 --force
Looking for 'mysql.exe' as: c:\mysql558\bin\mysql.exe
Looking for 'mysqlcheck.exe' as: c:\mysql558\bin\mysqlcheck.exe
Running 'mysqlcheck' with connection arguments: "--port=558"
Running 'mysqlcheck' with connection arguments: "--port=558"
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.func                                         OK
mysql.help_category
error    : Table upgrade required. Please do "REPAIR TABLE `help_category`" or dump/reload to fix it!
mysql.help_keyword
error    : Table upgrade required. Please do "REPAIR TABLE `help_keyword`" or dump/reload to fix it!
mysql.help_relation                                OK
mysql.help_topic
error    : Table upgrade required. Please do "REPAIR TABLE `help_topic`" or dump/reload to fix it!
mysql.host                                         OK
mysql.proc
error    : Table upgrade required. Please do "REPAIR TABLE `proc`" or dump/reload to fix it!
mysql.procs_priv
error    : Table upgrade required. Please do "REPAIR TABLE `procs_priv`" or dump/reload to fix it!
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name
error    : Table upgrade required. Please do "REPAIR TABLE `time_zone_name`" or dump/reload to fix it!
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK

Repairing tables
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_topic                                   OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.time_zone_name                               OK

How to repeat:
Copy a data folder from 5.0.91 to a 5.1.53 or 5.5.8 install. Run mysql_upgrade.

Suggested fix:
IF db=mysql THEN

s/error    : Table upgrade required. Please do "REPAIR TABLE `help_category`" or dump/reload to fix it!/Note: Will upgrade table `help_category` soon/

Or, if the "Repairing table" can be moved directly into that location (i.e repair one by one):

s/error    : Table upgrade required. Please do "REPAIR TABLE `help_category`" or dump/reload to fix it!/Upgrading table `help_category`     OK/

[21 Dec 2010 4:27] Roel Van de Paar

Small change to that last one:

s/error    : Table upgrade required. Please do "REPAIR TABLE `help_category`" or
dump/reload to fix it!/Note: Upgrading table `help_category`     OK/

This would be the best way IMO - clean/clear/transparent to the user

[23 Jul 2015 0:20] Paul DuBois

Noted in 5.7.9, 5.8.0 changelogs.

Output from mysql_upgrade is now less noisy and more informative.