MySQL 8: datadir

[Murray Eisenberg]

Andrew Audvare’s separate reply (for some reason not showing yet in my email, although sent before yours), advised:

	- stopmysql 5.7 [no problem: I can’t start it!!]

	- backup existing 5.7 database

	- move my.cnf to "appropriate location" <— not sure what this means! Surely I want it to be in /opt/local/etc/mysql8

	- start mysql8

BUT what about the mysql8 initialization step: do I want to SKIP that, since I already have a mysql 5.7 database to use (i.e., to upgrade automatically)?  Does the initialization do anything else besides creating a new database?


> On 2 Oct2020, at 5:37 PM, Ryan Schmidt <ryandesign at macports.org> wrote:
> 
> 
> 
> On Oct 2, 2020, at 15:45, Murray Eisenberg wrote:
> 
>> Step 6: Database upgrade as necessary
> 
> You used to have to upgrade the database manually but according to Oracle's documentation mysql 8.0.16 and later do it for you automatically.
> 
> 
> https://dev.mysql.com/doc/refman/8.0/en/upgrading-what-is-upgraded.html
> 
> 
> That's just one of many pages in the section of their manual on upgrading. There may be other useful information in there for you.
> 

---
Murray Eisenberg			murrayeisenberg at gmail.com
503 King Farm Blvd #101	Home (240)-246-7240
Rockville, MD 20850-6667	Mobile (413)-427-5334