database · mysql

unknown-table-engine-innodb

http://www.osterman.com/wordpress/2007/12/23/unknown-table-engine-innodb

 

I was getting the error “ERROR 1286 (42000): Unknown table engine ‘InnoDB’” when trying to create/alter tables with the InnoDB engine. You can check for this warning by issuing the create or alter statements and then running

show warnings;

in the same mysql client session.

Check if you have InnoDB support enabled:

mysql> show variables like ‘have_innodb’;
+—————+———-+
| Variable_name | Value    |
+—————+———-+
| have_innodb   | DISABLED |
+—————+———-+

The problem is that InnoDB is not enabled by default in Debian distributions of my.cnf.  To enable it, simply comment the following lines under the [mysqld] section.

#skip-innodb

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s