MySQL Forums
Forum List  »  Install & Repo

Can't complete upgrade from 5.5 to 5.6 (Mac OS)
Posted by: Rob Lewis
Date: August 17, 2016 08:59PM

I have been trying for days to complete an upgrade from 5.5, which worked fine for years, to 5.6.

I have reinstalled 5.6, and in my latest attempt, put this line in /private/etc/mysql/my.cnf:

datadir = /usr/local/mysql-5.5.10-osx10.6-x86_64/data

(Simply trying to point the server back at my 5.5 data directory that was working. It's backed up.)

It still won't see my old data. Here's what I get when trying to start the server in Terminal:

2016-08-17 16:52:09 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-08-17 16:52:10 0 [Note] mysqld (mysqld 5.6.32) starting as process 96949 ...
2016-08-17 16:52:10 96949 [Warning] Can't create test file /usr/local/mysql-5.5.10-osx10.6-x86_64/data/froghill.lower-test
2016-08-17 16:52:10 96949 [Warning] Can't create test file /usr/local/mysql-5.5.10-osx10.6-x86_64/data/froghill.lower-test
2016-08-17 16:52:10 96949 [Note] Plugin 'FEDERATED' is disabled.
2016-08-17 16:52:10 96949 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-08-17 16:52:10 96949 [Note] InnoDB: The InnoDB memory heap is disabled
2016-08-17 16:52:10 96949 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-08-17 16:52:10 96949 [Note] InnoDB: Memory barrier is not used
2016-08-17 16:52:10 96949 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-08-17 16:52:10 96949 [Note] InnoDB: Not using CPU crc32 instructions
2016-08-17 16:52:10 96949 [Note] InnoDB: Initializing buffer pool, size = 256.0M
2016-08-17 16:52:10 96949 [Note] InnoDB: Completed initialization of buffer pool
2016-08-17 16:52:10 96949 [Note] InnoDB: Highest supported file format is Barracuda.
2016-08-17 16:52:10 96949 [Warning] InnoDB: Resizing redo log from 2*320 to 2*3072 pages, LSN=5780163306
2016-08-17 16:52:10 96949 [Warning] InnoDB: Starting to delete and rewrite log files.
2016-08-17 16:52:10 7fff7e957000 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
2016-08-17 16:52:10 96949 [ERROR] InnoDB: Cannot create ./ib_logfile101
2016-08-17 16:52:10 96949 [ERROR] Plugin 'InnoDB' init function returned error.
2016-08-17 16:52:10 96949 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-08-17 16:52:10 96949 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-08-17 16:52:10 96949 [ERROR] Aborting

2016-08-17 16:52:10 96949 [Note] Binlog end
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'partition'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_METRICS'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_CMP'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'INNODB_TRX'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'BLACKHOLE'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'ARCHIVE'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'MRG_MYISAM'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'MyISAM'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'MEMORY'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'CSV'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'sha256_password'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'mysql_old_password'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'mysql_native_password'
2016-08-17 16:52:10 96949 [Note] Shutting down plugin 'binlog'
2016-08-17 16:52:10 96949 [Note] mysqld: Shutdown complete

It appears the two main problems may be in:
"can't create the test file", and
OS error 13 (some kind of permissions problem).

I'm apparently able to connect to the server with MySQL Workbench, but it doesn't see any of my old tables or users, and it reports "unknown" for Configuration File (which is definitely present in /private/etc/mysql/my.cnf; in OS X this is aliased from /etc/mysql/my.cnf).

I have tried everything I can think of but I'm stumped. Time for MariaDB?

Options: ReplyQuote


Subject
Written By
Posted
Can't complete upgrade from 5.5 to 5.6 (Mac OS)
August 17, 2016 08:59PM


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.