To determine whether your server supports
InnoDB
:
Issue the
SHOW ENGINES
statement to view the available MySQL storage engines.mysql> SHOW ENGINES;
Alternatively, query the
INFORMATION_SCHEMA.ENGINES
table.mysql> SELECT * FROM INFORMATION_SCHEMA.ENGINES;
(Now that
InnoDB
is the default MySQL storage engine, only very specialized environments might not support it.)If
InnoDB
is not present, you have amysqld
binary that was compiled withoutInnoDB
support and you need to get a different one.If
InnoDB
is present but disabled, go back through your startup options and configuration file and get rid of any--skip-innodb
option.