Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to enable InnoDB support in  MySQL ?

Posted on 2010-11-19
4
Medium Priority
?
762 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 26

Expert Comment

by:Umesh
ID: 34173411
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
ID: 34175389
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:Umesh
ID: 34178619
Is it new instance or copied from other box? pls confirm
0
 

Author Closing Comment

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

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

704 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