4

I am attempting to upgrade MySql server from version 5.6 to 5.7. After installing MySql server 5.6, I proceed to upgrade it by launching the installation wizard through .msi file of MySql5.7. It detects the existing server(5.6) on the system and gives me options to upgrade it but when I click that it look for upgrades through product catalog update. There is an option to install MySQL 5.7 server but it creates a separate instance, service and directory. I want the existing server to be upgraded, Is there any way to do that through this wizard?

When I try to upgrade 5.6 to 5.7 I get this message Is there any way by which we can upgrade by not referring to product catalog update?

Why is it looking for upgrade online when the msi for 5.7 is already present in the "C:\ProgramData\MySQL\MySQL Installer for Windows\Product Cache" folder? Here is a screen shot of the product cache folder, it already has msi for 5.7

It is noteworthy, that no such thing happens when I upgrade from 5.6.31 to 5.6.35. The upgrade is seamless and does not require any internet connection, why it happens differently when I try to upgrade from 5.6 to 5.7?

following is the link to a similar question - upgrading to MySQL 5.7 from 5.6

Journeyman Geek
  • 133,878
RishabhK
  • 51

2 Answers2

1

From what I can tell, the MSI based installer will let you upgrade the minor versions but not the major. So you can update 5.5.xx to a newer 5.5.xx but not to 5.7. It seems to want to create multiple installs with a new install for each major version, so a 5.5 install alongside a 5.7.

boomhauer
  • 145
0

It can't upgrade the server probably because something is incompatible, or the upgrader can't check for updates from server because firewall/ip blocking.

My advice, is to dump all databases in your MySQL server, uninstall MySQL 5.6 and perform a clean install of 5.7. Then, restore all dumps. However, if you have no great need to do an upgrade, you can also avoid to do it.

Northumber
  • 141