Bug #20921 mysql_upgrade

• Submitted: 8 Jul 2006 21:52
• Modified: 19 Jul 2006 1:36
• Reporter: Peter Laursen (Basic Quality Contributor)
• Status: Closed
• Category: MySQL Server: Packaging
• Severity: S3 (Non-critical)
• Version: 5.0.23
• OS: Windows (WinXP)
• CPU Architecture: Any

[8 Jul 2006 21:52] Peter Laursen

Description:
According to the changelogs the mysql_upgrade program is now a C program and it should be possible to execute it on Windows.

A quote from http://dev.mysql.com/doc/refman/5.0/en/news-5-0-23.html
"The mysql_upgrade command has been converted from a shell script to a C program, so it is available on non-Unix systems such as Windows. This program should be run for each MySQL upgrade. See Section 5.6.2, “mysql_upgrade — Check Tables for MySQL Upgrade”."

After upgrading form 5.0.22 to 5.0.23 a file named 'mysql_upgrade' is in the 'script' folder.  Now a file without an extension is not an executable one on Windows.  I would have expected it to be an .exe? 

But it is not a binary at all as far as I can see!
Looks like it is still a *nix shell script!

We have an old bug report here:
http://bugs.mysql.com/bug.php?id=18115
.. now it does not help that Paul update the changelogs and the docs if things do not happen!

How to repeat:
try this on Windows:
http://dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.html

.. and be confused!

Suggested fix:
explain how to use the mysql_upgrade program on Windows! 
And provide a true binary for Windows.

BTW: this page
http://dev.mysql.com/doc/refman/5.0/en/windows-upgrading.html
could need an update too I think!

[9 Jul 2006 16:46] MySQL Verification Team

I am awaiting until the version 5.0.23 will be available on our
public download page for to process it.

[9 Jul 2006 19:06] Peter Laursen

That is your choice!

However I should think that - once distribution to mirrors have started - that MySQL AB would like to spot issues at as early stage as possible.

[10 Jul 2006 20:54] MySQL Verification Team

Is there in your \bin install directory the below binary?

c:\mysql\bin>dir mysql_upgrade.exe
 O volume na unidade C não tem nome.
 O número de série do volume é C0FB-E588

 Pasta de c:\mysql\bin

2006-07-05  17:56         1.200.128 mysql_upgrade.exe
               1 arquivo(s)      1.200.128 bytes
               0 pasta(s) 15.437.737.984 bytes disponíveis

c:\mysql\bin>

I verified with the package: mysql-noinstall-5.0.23-win32.zip

Thanks in advance.

[10 Jul 2006 21:08] Peter Laursen

Yes ..

and when trying to execute it I get

"unknown variable 'default-character-set=latin1'"
(I have this line in my my.ini)

Another user has posted a bug report with another bug report, that 'mysql_upgrade.exe' on windows looks for 'mysql_check' and not 'mysql_check.exe'
So thanks to this user I found the executable allready ...  

If it makes things easier for you you can close this report (or mark as 'a dublicate' for instance), as I added a comment in the other one.

The fix_privileges SQL-script still works fine :-)

[19 Jul 2006 1:36] MySQL Verification Team

Thank you for the feedback. I am closing this bug report.