Bug #46017 add runtime version checking to mysql_upgrade
Submitted: 7 Jul 2009 18:07 Modified: 4 Oct 2010 13:17
Reporter: Scott Noyes Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server: Installing Severity:S4 (Feature request)
Version:any OS:Any
Assigned to: CPU Architecture:Any

[7 Jul 2009 18:07] Scott Noyes
mysql_upgrade does not verify which version it is running against. If you use the wrong version, you can get mysterious errors, which require some experience to diagnose.

How to repeat:
Run the 5.1 mysql_upgrade against a 5.0 server, and it will fail with errors about unknown options (have_csv, for one).

Suggested fix:
Add a SELECT VERSION() and notify the user if the major version doesn't match.
[4 Oct 2010 13:17] Susanne Ebrecht
This is a duplicate of bug #42028