Re: InnoDB engine missing
Posted by: Robert McClean
Date: February 22, 2011 10:26AM
I know this is an aging post, but this is what I found to be the problem and answer:
o When you install MySql using apt-get it automatically starts MySql...
o ...using the default configuration
o you then change the configuration to suit your tuning needs
(eg nice big innodb_log_file_size)
o you stop and restart mysql and find...
o ...InnoDB engine not present, AND
o ...existing InnoDB tables in an unusable state
o after installing MySql, but before tuning the configuration...
o ...service mysql stop
o ...cd /var/lib/mysql
o ...mv ib_logfile0 ib_logfile0.bk
o ...mv ib_logfile1 ib_logfile1.bk
o tune your config
o service mysql start
o Voilà - it works (unless you broke something else :D )
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.