Ben, what does SHOW ENGINES show you? It should list all known storage
engines and indicate whether your MySQL install supports it or not.
Here's mine (5.0.21) for comparison; I was able to create a test table
as InnoDB and the SHOW CREATE showed it as InnoDB:
-> show engines;
+------------+---------+----------------------------------------------------------------+
| Engine | Support | Comment
|
+------------+---------+----------------------------------------------------------------+
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great
performance |
| MEMORY | YES | Hash based, stored in memory, useful for
temporary tables |
| InnoDB | YES | Supports transactions, row-level locking, and
foreign keys |
| BerkeleyDB | NO | Supports transactions and page-level locking
|
| BLACKHOLE | NO | /dev/null storage engine (anything you write to
it disappears) |
| EXAMPLE | NO | Example storage engine
|
| ARCHIVE | YES | Archive storage engine
|
| CSV | NO | CSV storage engine
|
| ndbcluster | NO | Clustered, fault-tolerant, memory-based tables
|
| FEDERATED | NO | Federated MySQL storage engine
|
| MRG_MYISAM | YES | Collection of identical MyISAM tables
|
| ISAM | NO | Obsolete storage engine
|
+------------+---------+----------------------------------------------------------------+
12 rows in set (0.00 sec)
Ben Clewett wrote:
> Hi Gerald,
>
> 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:
>
> --innodb
>
> 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
>
>
> gerald_clark wrote:
>> 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.
>>
>
>
