asked on

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 ?

Umesh

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

ASKER CERTIFIED SOLUTION

pvg13

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Umesh

Is it new instance or copied from other box? pls confirm

pvg13

ASKER

Tried multitude of options and this solution was the only one that worked.