MySQL 8: datadir
murrayeisenberg at gmail.com
Fri Oct 2 22:17:47 UTC 2020
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.
> 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
More information about the macports-users