Ben Clewett wrote:
> Dear MySQL,
> I've installed 5.1.9 from source on a SUSE 10 box. But I can't get
> InnoDB tables respected.
> I have used the correct compilation flag (--with-innodb).
> SHOW VARIABLES; lists all the usual innodb variables.
> The innodb table space has been created in ~/var/ibdata1.
> But if I enter:
> CREATE TABLE a (
> a int NOT NULL PRIMARY KEY
> ) ENGINE=InnoDB;
> SHOW CREATE TABLE a;
> CREATE TABLE `a` (
> `a` int(10) NOT NULL PRIMARY KEY
> ) ENGINE=MyISAM
> As you can see, an InnoDB has become an MyISAM and will be stored in
> I am using the large table .cnf file. Everything else is much as
> Can anybody help me?
make sure you don't have
in your my.cnf file.