MySQL Forums
Forum List  »  Install & Repo

Re: Can't complete upgrade from 5.5 to 5.6 (Mac OS)
Posted by: Peter Brawley
Date: August 23, 2016 11:51AM

> (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?

Options: ReplyQuote


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.