MySQL Bugs: #96279: Need a description for OFFLINE upgrade with MySQL Installer

Bug #96279	Need a description for OFFLINE upgrade with MySQL Installer
Submitted:	23 Jul 2019 2:56	Modified:	9 Aug 2024 22:29
Reporter:	Meiji Kimura	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:		OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
In this bug, the developper explain about OFFLINE upgrade procedure with MySQL Installer.

https://bugs.mysql.com/bug.php?id=72176

- install the update msi and close the GUI
- open a windows console window (under administrative privileges)
- navigate to the mysql installer directory (usually found under %ProgramFiles%\MySQL\MySQL Installer)
- execute the following command:
  MySQLInstallerConsole.exe --action=upgrade

But the manual don't have any description for these procedure. So please add a description for that, and need update for MySQL Installer with MySQL 5.7, 8.0.

How to repeat:
See Description, and How to fix.

Suggested fix:
So please add a description for that, and need update for MySQL Installer with MySQL 5.7, 8.0.

For example, In this version of MySQL Installer, did the same procedure, returned "--action=upgrade is not a support action" and MySQL Client menu became don't work.

Before update：MySQL Server 5.7.18.1
After update：MySQL Server 5.7.19 

After that procedure, we have to change path of MySQL Client menu's property as belows. (Need to change path from "Program Files" to "ProgramData"

"C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql.exe" "--defaults-file=C:\Program Files\MySQL\MySQL Server 5.7\my.ini" "-uroot" "-p"
↓
"C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql.exe" "--defaults-file=C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" "-uroot" "-p"

Need to update the procedure for MySQL 5.7 and 8.0.

Hello Meiji-San,

Thank you for the report and feedback.

regards,
Umesh

Posted by developer:
 
That shows "--action=upgrade is not a support action" for "--action=upgrade" because that's not a standalone action, rather it's part of help. So, "MySQLInstallerConsole.exe help --action=upgrade" shows help for the upgrade command, so help for "MySQLInstallerConsole upgrade".

This information is documented here:

https://dev.mysql.com/doc/refman/8.0/en/MySQLInstallerConsole.html