MySQL Forums
Forum List  »  InnoDB

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
5725
December 01, 2010 12:14PM
2657
December 01, 2010 12:22PM
2624
December 04, 2010 02:27PM
Re: InnoDB engine missing
12964
February 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.