How to enable have_innodb variable

[Tata Rao]

Hi Forum,

I have instlled MySQL 5.0.14 Community Server on RHEL4. I have created the database using default MyISAM engine but now i want to change engine type of the database from MyISAM to InnoDB. To do so, I have tried to alter the tables by using alter statement but it is not getting changed to InnoDB.
Afterwards, i came to know that InnoDB engine is disabled in our instance.

Here are the outputs of InnoDB engine status of our instance:

mysql> show variables like '%have_inn%';
+---------------+----------+
| Variable_name | Value |
+---------------+----------+
| have_innodb | DISABLED |
+---------------+----------+
1 row in set (0.01 sec)

mysql> show engine innodb status;
ERROR 1235 (42000): Cannot call SHOW INNODB STATUS because skip-innodb is defined



So, I tried with following options to make have_innodb variable enable:

option 1: mysql> mysqld --have_innodb = YES

Option 2: Modified value of "innodb_data_file_path" from ibdata1:10M:autoextend to ibdata1:10M:autoextend:max:128M.

Please let me know if you know how to enable the innodb engine. It is very urgent.

Regards
Tata