Re: How can I enable the InnoDB engine?

[himanshu saraf]

hi

I have the same problem. Im mysql, InnoDB engine is disabled, Setting written in my.cnf file is given below.

# InnoDB settings
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:100M:autoextend
set-variable = innodb_buffer_pool_size=100M
set-variable = innodb_additional_mem_pool_size=10M
innodb_flush_log_at_trx_commit=1

Above code does create the files mentioned, but doesn't enable my InnoDB engine.
Also i tried adding

default_storage_engine = InnoDB

but mysqld service fails to start. I am using MYSQL Server 5.0.27

thx

himanshu