List:General Discussion« Previous MessageNext Message »
From:gerald_clark Date:May 23 2006 1:09pm
Subject:Re: InnoDB problems under 5.1.9
View as plain text  
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 
> ~/var/test/a.*
>
> I am using the large table .cnf file.  Everything else is much as 
> default.
>
> Can anybody help me?
>
> Regards,
>
> Ben

make sure you don't have
skip--innodb
in your my.cnf file.

Thread
InnoDB problems under 5.1.9Ben Clewett23 May
  • RE: InnoDB problems under 5.1.9SST - Adelaide)23 May
    • Re: InnoDB problems under 5.1.9Ben Clewett23 May
      • RE: InnoDB problems under 5.1.9SST - Adelaide)23 May
        • Re: InnoDB problems under 5.1.9Ben Clewett23 May
        • I think I need a joinCritters23 May
          • Re: I think I need a joinPeter Brawley23 May
    • How do I get off this list that I do not remember joining in the first place!!!!Phil Robbins25 May
      • Re: How do I get off this list that I do not remember joining inthe first place!!!!Daniel Kasak25 May
        • Re: How do I get off this list that I do not remember joining in the firstplace!!!!Phil Robbins26 May
          • Re: How do I get off this list that I do not remember joining inthe first place!!!!James Harvard26 May
          • Re: How do I get off this list that I do not remember joining inthe first place!!!!Daniel Kasak26 May
      • RE: How do I get off this list that I do not remember joining in the first place!!!!Tim Lucia25 May
  • Re: InnoDB problems under 5.1.9gerald_clark23 May
    • Re: InnoDB problems under 5.1.9Ben Clewett23 May
    • Re: InnoDB problems under 5.1.9Ben Clewett23 May
      • Re: InnoDB problems under 5.1.9Dan Buettner23 May
        • Re: InnoDB problems under 5.1.9Ben Clewett23 May
          • Re: InnoDB problems under 5.1.9Dan Buettner23 May
            • Re: InnoDB problems under 5.1.9Ben Clewett23 May
            • Re: InnoDB problems under 5.1.9Ben Clewett23 May