Bug #61813 Instance Config Wizard canot upgrade existing instance
Submitted: 10 Jul 2011 16:38 Modified: 25 Mar 2012 13:11
Reporter: Anthony Marston Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Config Wizard Severity:S2 (Serious)
Version:5.5.14, 5.5.16 OS:Windows (XP 32 bit)
Assigned to: CPU Architecture:Any

[10 Jul 2011 16:38] Anthony Marston
Description:
This is a follow-on from bug #61812 where the Instance Config Wizard does not start automatically at the end of the upgrade process.

I start the Instance Config Wizard manually and step through all the pages without changing anything except the character set from latin1 to utf-8. I get the following unexpected dialog boxes:

1) It seems that port 3306 is already in use. Are you sure you want to us this port? I answer YES.

2) A Windows service with the name MySQL already exists. Please uninstall this service correcty or choose a different name for the new service.

The config wizard does not give me the option to uninstall the existing instance or to upgrade the existing instance, only to create a new one. When I am upgrading to a new version of MySQL I expect it to upgrade the exsiting instance automatically.

How to repeat:
Upgrade from an earlier version to 5.5.14 and start the Instance Config Wizard manually.
[11 Jul 2011 7:20] Valeriy Kravchuk
Are you sure you had started Config. Wizard from correct version? 

It was not started in my case, no shortcut was created for menu, but when started manually from "C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqlinstanceconfig.exe" it worked as expected...
[11 Jul 2011 8:09] Anthony Marston
I only have one copy of the Instance Config Wizard on my PC, and that exists at "F:\MySQL\MySQL Server 5.5\bin\MySQLInstanceConfig.exe". The file is dated 26/08/2010 and is 2,973,600 bytes in size.
[11 Jul 2011 22:02] MySQL Verification Team
On Windows 2003 server 32-bit I upgraded 5.1.58 to 5.5.14 without problem the only issue I noticed is the not remove of the menu item for the 5.1.58 command line.
[16 Sep 2011 9:32] Anthony Marston
This problem still exists in version 5.5.16

The instance config wizard does not start automatically after uprading from 5.5.15, and if I start it manually it does not upgrade the existing instance, it wants to create a new instance with a different name on a different port.
[25 Mar 2012 12:59] Valeriy Kravchuk
Please, check if this problem still happens with a recent version, 5.5.22.
[25 Mar 2012 13:11] Anthony Marston
That problem ocurred on my old laptop running Windows XP, but since my wife spilled her drink over my laptop and I've had to replace it with a brand new one running Windows 7, and since then the problem no longer appears. You can consider this ticket closed.