Bug #20921 mysql_upgrade

Submitted: 8 Jul 2006 21:52 Modified: 19 Jul 2006 1:36
Reporter: Peter Laursen (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Packaging Severity:S3 (Non-critical)
Version:5.0.23 OS:Windows (WinXP)
Assigned to: 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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.053 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.