MySQL Forums
Forum List  »  InnoDB

ERROR 1286 (42000): Unknown table engine 'InnoDB'
Posted by: Jean-Baptiste Cazier
Date: April 26, 2007 04:08AM

Hello,

I am running mysql 5.0.22 on a Fedora Core 5 box.
So far it worked fine witht he default MyISAM engine.

However I now need some InnoDB tables and I cannot get them because I get the
Unknown table engine 'InnoDB' Error message:


mysql> CREATE TABLE t ( i INT NOT NULL AUTO_INCREMENT PRIMARY KEY ) ENGINE = InnoDB ;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> show warnings;
+---------+------+-------------------------------------------+
| Level | Code | Message |
+---------+------+-------------------------------------------+
| Warning | 1266 | Using storage engine MyISAM for table 't' |
+---------+------+-------------------------------------------+
1 row in set (0.00 sec)

mysql> SET storage_engine = InnoDB;
ERROR 1286 (42000): Unknown table engine 'InnoDB'


I installed the standard MySQL packages on Fedora without fiddling with it. It should be including InnoDB
What shall I do to enable InnoDB, or see why it is unknown ?


Thanks

Jean-Baptiste

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.