MySQL 5.6 Reference Manual Including MySQL NDB Cluster 7.3-7.4 Reference Guide
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 a
mysqld
binary that was compiled without
InnoDB
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.