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'
92962
April 26, 2007 04:08AM
50024
April 27, 2007 06:53AM
39146
April 28, 2007 06:07PM
35156
March 21, 2008 01:56AM
29916
March 25, 2008 07:46AM
25048
July 01, 2008 07:32AM
21989
April 22, 2009 10:41AM
25558
May 14, 2009 07:50PM
23548
June 29, 2009 08:37AM
22237
April 30, 2009 11:24PM
24531
May 16, 2009 11:10PM
21393
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.