Re: Can't complete upgrade from 5.5 to 5.6 (Mac OS)
> (Simply trying to point the server back at my 5.5 data directory that was working. It's backed up.)
All major versions (and some minor ones) change table structures in the mysql database; the new version won’t run correctly, or won’t run at all, until these changes are written to your mysql database.
So such an upgrade needs the first server start to be with a new datadir, and with --skip-grant-tables to disable privilege checking, then run mysql_upgrade. Stop the server and restart normally to verify that it's running without error. Then load the dump script from the previous instance in the Mysql client with
source c:/backup/mysqlbackup.sql
> InnoDB: The error means mysqld does not have the access rights to
> InnoDB: the directory.
Do the suggetions at
http://stackoverflow.com/questions/9186326/cant-get-mysql-5-5-running-on-mac-10-6 help?
Subject
Written By
Posted
Re: Can't complete upgrade from 5.5 to 5.6 (Mac OS)
August 23, 2016 11:51AM
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.