Subj : Non in-place upgrade of MySQL 5.7 to 8
To   : All
From : hyjinx
Date : Mon Jul 19 2021 16:46:46

Hi All,

I'm building a new box. It was about time I got my A-into-G. My current
webserver runs Ubuntu 18.04, and whilst it's still LTS supported for a couple
of more years, running PHP 7.2 irks me, plus it's a nice chance to migrate
the box from Germany to USA. 

ãSo, I've built a new box running Ubuntu Server 20.04. Grand. It comes with
MySQL 8 out of the box. It seems I've been asleep for a lot longer than I
thought, because Ubuntu 18.04 runs MySQL 5.7.34, and there is no 'simple'
upgrade path. A lot of things have changed, so my usual:
mysqldump --all-databases > foo.sql won't cut the mustard. If I import that
into MySQL 8, it tells me that it hates the mysql table and gives up, can't
even run the mysql_upgrade tool. After a few hours of googling, this is a
well known matter (thanks Oracle), but I can't seem to find anyone that
suggests how I can migrate the databases WITHOUT having to set up all the
accounts manually again (i.e., create new mysql users and set new passwords).
This is pretty much a no go; I'd have to reach out to my clients and get them
to give me new passwords and then reconfigure their websites to use the new
passwords. I see much breakage and annoyed customers calling me.

Surely, there is a way I can do some scripting or some tool can automate the
migration? Any ideas?

Cheers,
Al


hyjinx // Alistair Ross
Author of 'Back to the BBS' Documentary: https://bit.ly/3tRINeL (YouTube)
alsgeeklab.com

--- Mystic BBS v1.12 A46 2020/08/26 (Linux/64)
 * Origin: Sent from Al's Geek Lab 1337:2/104 (1337:2/104)

.