MySQL Forums
Forum List  »  Install & Repo

mysql_upgrade from 5.5.31 to 5.6.10 fails when no InnoDB engine
Posted by: Gary Burchett
Date: June 27, 2013 05:04PM

I have a database running under 5.5.31 with no InnoDB engine (skip-innodb). I am able to start 5.6.10 with InnoDB off on this database (innodb=OFF, skip-innodb, default-storage-engine=MYISAM, default-tmp-storage-engine=MYISAM, and a bunch of loose-innodb=*=0 options). When I try to run mysql_upgrade I get these errors:

Running 'mysql_fix_privilege_tables'...
ERROR 1286 (42000) at line 36: Unknown storage engine 'INNODB'
ERROR 1286 (42000) at line 45: Unknown storage engine 'INNODB'
ERROR 1146 (42S02) at line 1877: Table 'mysql.innodb_table_stats' doesn't exist
ERROR 1146 (42S02) at line 1878: Table 'mysql.innodb_index_stats' doesn't exist
FATAL ERROR: Upgrade failed

It appears that mysql_upgrade may require InnoDB to be running. If I do enable InnoDB on the database, then the mysql_upgrade completes successfully. We have no need for innodb on this database.

Is this now a requirement? a bug? a feaature? or something I am doing wrong?

Options: ReplyQuote


Subject
Written By
Posted
mysql_upgrade from 5.5.31 to 5.6.10 fails when no InnoDB engine
June 27, 2013 05:04PM


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.