Subj : Re: Non in-place upgrade of MySQL 5.7 to 8
To   : hyjinx
From : MeaTLoTioN
Date : Mon Jul 19 2021 09:01:21

 
On 19 Jul 2021, MeaTLoTioN said the following...
 
 Me> On 19 Jul 2021, hyjinx said the following...
 Me>  
 Me>  hy> Thanks dude. Unfortunately that link is one of the many links I alrea
 Me>  hy> read.
 Me>  hy> 
 Me>  hy> The main problem is this bit:
 Me>  hy>  Me> Personally, I would recreate the dump without mysql schema.
 Me>  hy> 
 Me>  hy> That's fine - but the main problem is how do I Migrate the users acro
 Me>  hy> Dumping the databases sans the mysql database is easy enough, but I s
 Me>  hy> need the user from mysql.users at the very least, right?
 Me> 
 Me> Hmm, wouldn't the users be in the .sql file though? only the schema
 Me> wouldn't,no?
 Me> 
 Me> In the example, he's grabbing the mysql db along with the others, and
 Me> the userstable is within this db, so I would have thought it would
 Me> include the usersdata?
 Me> 

Unless I actually _read_ the last line...

"To clarify, when I've completed the restore I'll have to create users in MYSQL 






















































































































































































































































































































































































































































































































































































































































































































































































8.0 to match the original users in the MYSQL5.7 database?"

I think that's exactly what you said, so now I'm at a loss.

---
|14Best regards,
|11Ch|03rist|11ia|15n |11a|03ka |11Me|03aTLoT|11io|15N

|07ÄÄ |08[|10eml|08] |15ml@erb.pw |07ÄÄ |08[|10web|08] |15www.erb.pw |07ÄÄÄ¿
|07ÄÄ |08[|09fsx|08]  |1521:1/158 |07ÄÄ |08[|11tqw|08] |151337:1/101 |07ÂÄÄÙ
|07ÄÄ |08[|12rtn|08] |1580:774/81 |07ÄÂ |08[|14fdn|08] |152:250/5 |07ÄÄÄÙ
|07ÄÄ |08[|10ark|08]  |1510:104/2 |07ÄÙ

--- Mystic BBS v1.12 A47 2020/12/04 (Linux/64)
 * Origin: thE qUAntUm wOrmhOlE, rAmsgAtE, uK. bbs.erb.pw (1337:1/101)

.