MySQL Forums :: InnoDB :: InnoDB engine missing

Advanced Search

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 /var/lib/mysql
o ib_logfile0 ib_logfile0.bk
o ib_logfile1 ib_logfile1.bk
o tune your config
o service mysql start
o VoilĂ  - it works (unless you broke something else :D )

Options: ReplyQuote

Subject Views Written By Posted
InnoDB engine missing 4914 Ronald Albury 12/01/2010 12:14PM
Re: InnoDB engine missing 2235 Ronald Albury 12/01/2010 12:22PM
Re: InnoDB engine missing 2196 Rick James 12/04/2010 02:27PM
Re: InnoDB engine missing 7964 Robert McClean 02/22/2011 10:26AM

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.