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
681
March 12, 2021 06:11PM
618
March 12, 2021 07:44PM
381
March 12, 2021 08:12PM
389
March 12, 2021 08:26PM
368
March 14, 2021 10:01AM
368
March 12, 2021 09:24PM
249
February 09, 2022 09:22PM
229
February 09, 2022 09:24PM
231
February 09, 2022 09:31PM
263
February 10, 2022 01:55PM
279
February 11, 2022 01:04PM
241
February 11, 2022 01:06PM
242
February 11, 2022 01:13PM
Re: Upgrade Error
268
February 11, 2022 03:15PM
302
February 12, 2022 08:16PM
273
February 12, 2022 09:10PM
569
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.