• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 778
  • Last Modified:

How to enable InnoDB support in MySQL ?

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
pvg13
Asked:
pvg13
  • 2
  • 2
1 Solution
 
UmeshMySQL Principle Technical Support EngineerCommented:
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
 
pvg13Author Commented:
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
 
UmeshMySQL Principle Technical Support EngineerCommented:
Is it new instance or copied from other box? pls confirm
0
 
pvg13Author Commented:
Tried multitude of options and this solution was the only one that worked.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Managing Security & Risk at the Speed of Business

Gartner Research VP, Neil McDonald & AlgoSec CTO, Prof. Avishai Wool, discuss the business-driven approach to automated security policy management, its benefits and how to align security policy management with business processes to address today's security challenges.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now