To determine whether your server supports
InnoDB:
Issue the command
SHOW ENGINES;to see all the different MySQL storage engines. Look forDEFAULTin theInnoDBline. Alternatively, query theINFORMATION_SCHEMAENGINEStable. (Now thatInnoDBis the default MySQL storage engine, only very specialized environments might not support it.)Issue the command
SHOW VARIABLES LIKE 'have_innodb';to confirm thatInnoDBis available.If
InnoDBis not present, you have amysqldbinary that was compiled withoutInnoDBsupport and you need to get a different one.If
InnoDBis present but disabled, go back through your startup options and configuration file and get rid of anyskip-innodboption.