ERROR 1286 (42000): Unknown table engine 'InnoDB'
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
Subject
Views
Written By
Posted
ERROR 1286 (42000): Unknown table engine 'InnoDB'
92984
April 26, 2007 04:08AM
50036
April 27, 2007 06:53AM
39156
April 28, 2007 06:07PM
35164
March 21, 2008 01:56AM
29927
March 25, 2008 07:46AM
25060
July 01, 2008 07:32AM
21999
April 22, 2009 10:41AM
25573
May 14, 2009 07:50PM
23555
June 29, 2009 08:37AM
22243
April 30, 2009 11:24PM
24538
May 16, 2009 11:10PM
21402
May 17, 2009 01:00AM
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.