I am sure I don't have this in my my.cfg. I am using the supplied
'large table' my.cfg. The *only* innodb option I have is the command
line parameter to mysqld:
If anybody has any other options about how to get innodb working in
5.1.9, I'd be very interested!
Thanks for the advise,
> 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.