why is an error being generated when i change the engine to INNODB in Sqlyog?

Question

I'm trying to create a database in Sqlyog and i would like to set the engine to INNODB. However when I execute the sql command to alter from MyISAM to INNODB, the following error is displayed:

Warning Code : 1286
Unknown storage engine 'innodb'

Does any of you know how to solve this problem please as I would like to use foregin keys and they are not allowed with MyISAM

thanks a lot for your help

Answer 1

Execute

SHOW ENGINES;

and check whether InnoDB engine is supported or not for your server. If it is not supported then:

1) You can try removing ib_logfile0 and ib_logfile1 from the data directory of the installation folder. And restart the server beacuse MySQL seems to disable it automatically if your InnoDB log files get corrupted. When you remove them, they are recreated, allowing InnoDB to start again.

OR

2) http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html#option_mysqld_innodb refer this link and check if --skip-innodb is enabled or not.If skip inndob line is present in my.ini/my.cnf just comment-out that line.