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.




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to