Solved

How to enable InnoDB support in  MySQL ?

Posted on 2010-11-19
4
751 Views
Last Modified: 2012-06-27
Just installed the latest verson of MYSQL Server.  It will not start with INNODB enabled.  I need INNODB support.  I need to ENABLE it.  It is NOT Disabled in the ini file.  However, to start mysql, I need to disable it in the ini file.

The HAVE_INNODB Variable in the info-schemo database is set to NO.  I can't change this to YES.  Could this be the problem?  How do I change it ?
0
Comment
Question by:pvg13
  • 2
  • 2
4 Comments
 
LVL 26

Expert Comment

by:ushastry
Comment Utility
Hi,

Could you post the recent error log contents???

Also, comment out if there is any skip-innodb line from the config file and make sure below line exists in the config file.. change the path "/path/to/mysql/data/" to exact path in below section.. once you ensured that below line exists then restart MySQL and confirm from show engines/ have% etc

innodb_data_home_dir = /path/to/mysql/data/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /path/to/mysql/data/
innodb_log_arch_dir = /path/to/mysql/data/

innodb_buffer_pool_size=16M
innodb_additional_mem_pool_size=2M

innodb_log_file_size=5M
innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_lock_wait_timeout=50
0
 

Accepted Solution

by:
pvg13 earned 0 total points
Comment Utility
Found the solution.

Stop Mysql Service.

Go into mysql data directory.

Locate the ib*.* files

Make a backup of the ib*.* files

Delete ib*.* files

Start Mysql Server

It recreates the files and everything is running fine!

-Pete
0
 
LVL 26

Expert Comment

by:ushastry
Comment Utility
Is it new instance or copied from other box? pls confirm
0
 

Author Closing Comment

by:pvg13
Comment Utility
Tried multitude of options and this solution was the only one that worked.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now