Skip navigation links

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:

PROBLEM
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

ANSWER
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 )

Options: ReplyQuote


Subject Views Written By Posted
InnoDB engine missing 3944 Ronald Albury 12/01/2010 12:14PM
Re: InnoDB engine missing 1855 Ronald Albury 12/01/2010 12:22PM
Re: InnoDB engine missing 1852 Rick James 12/04/2010 02:27PM
Re: InnoDB engine missing 3974 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.