Re: Can't restore databases, Error 1214
I would have expected the dump to write out ... ENGINE=MyISAM ..., but it seems to have left that off, or maybe you have "force" turned on in 5.5.
Try this in my.cnf (and restart mysqld):
default_storage_engine = MyISAM
If that does not work, please dump these from 5.5 for us:
SHOW VARIABLES;
SHOW GLOBAL STATUS;
Subject
Views
Written By
Posted
5978
May 16, 2013 07:30AM
Re: Can't restore databases, Error 1214
2520
May 17, 2013 11:42PM
2398
May 22, 2013 01:56AM
2109
May 24, 2013 07:29PM
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.