Bug #53938 mysql_upgrade does not updates help tables
Submitted: 24 May 2010 10:14 Modified: 28 Jul 2010 10:01
Reporter: Sveta Smirnova Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:5.1, all OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[24 May 2010 10:14] Sveta Smirnova
This is split from bug #45121.

mysql_upgrade doesn't upgrade data in help tables and prints no word about this
should be done.

Note for case when mysql_upgrade fixes help table: please ensure SET SQL_LOG_BIN = 0 is
called to ENSURE that these commands are NOT replicated downstream.

There also can be new option --upgrade_help_tables[=0|1]

How to repeat:
See description.
[24 May 2010 10:16] Sveta Smirnova
See also closed documentation bug #53285.
[28 Sep 2017 7:17] Walter Schober
I wonder why "SET SQL_LOG_BIN = 0" is not in all upgrade scripts for a long time. Very annoying each time upgrading (even minor) a replication master.