Re: Upgrade Error
Posted by: Peter Brawley
Date: February 11, 2022 03:15PM

> The archive doesn't even show a 5.7.37

What archive?

5.7.37 was released 18 Jan this year, https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-37.html. According to the log excerpt you posted, you have successfully updated to 5.7.37.

> I don't work in the cli ...

Yikes. GUIs are designed to protect the user from being overwhelmed by detail, but relational databases are complicated beasts, they're all about the complicated details that GUIs tend to hide. By restricting yourself to GUIs, you tie your hands behind your back.

> I havn't done that [mysqldump before upgrade],
> because that is what the installer is trying to do.

That's an error. At https://dev.mysql.com/doc/refman/8.0/en/windows-upgrading.html, MySQL manual says "Whichever approach you choose, always back up your current MySQL installation before performing an upgrade."

> Can I manually copy over the mysql files and then issue the upgrade command?

File copy is reliable for MySQL backup/restore if and only if (i) the file copy was done while MySQL was not running, (ii) after an error-free shutdown, (iii) you copied all relevant files (it's possible to configure InnoDB to scatter its files anywhere). And in-place upgrade from 5.7 to 8.0 is more complicated, see https://dev.mysql..com/blog-archive/upgrading-to-mysql-8-0-here-is-what-you-need-to-know/

Given the complexities of upgrading from 5.7 to 8.0, my approach has been to do a logical upgrade ...

(i) run the new upgrade checker (https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-utilities-upgrade.html) to see what problems lie ahead,

(ii) mysqldump all 5.7 dbs except mysql (8.0 mysql db is seriously backward-incompatible with 5.7)

(iii) install 8.0 with the installer,

(iv) manually add users to the 8.0 installation,

(v) fix any issues from (i) that I can at this stage

(vi) import the 5.7 mysqldump,

(vii) fix remaining upgrade issues following guidelines from (i).



Edited 2 time(s). Last edit at 02/11/2022 04:01PM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
820
March 12, 2021 06:11PM
720
March 12, 2021 07:44PM
449
March 12, 2021 08:12PM
469
March 12, 2021 08:26PM
486
March 14, 2021 10:01AM
441
March 12, 2021 09:24PM
378
February 09, 2022 09:22PM
289
February 09, 2022 09:24PM
292
February 09, 2022 09:31PM
341
February 10, 2022 01:55PM
410
February 11, 2022 01:04PM
371
February 11, 2022 01:06PM
316
February 11, 2022 01:13PM
Re: Upgrade Error
351
February 11, 2022 03:15PM
371
February 12, 2022 08:16PM
359
February 12, 2022 09:10PM
827
February 09, 2022 08:40PM


Sorry, you can't reply to this topic. It has been closed.

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.