Is your server configured with "skip-innodb" ? It's an option that turns off support to that engine forcing it to elect a different method of storage.
Shawn Green Database Administrator Unimin Corporation - Spruce Pine "P. Evans" <[EMAIL PROTECTED]> wrote on 11/10/2005 10:10:44 AM: > Here's an example : > mysql> create table petest (col1 integer,col2 char(5)) engine=innodb; > Query OK, 0 rows affected, 1 warning (0.07 sec) > mysql> show warnings > -> ; > +---------+------+------------------------------------------------+ > | Level | Code | Message | > +---------+------+------------------------------------------------+ > | Warning | 1266 | Using storage engine MyISAM for table 'petest' | > +---------+------+------------------------------------------------+ > 1 row in set (0.00 sec) > > Jasper Bryant-Greene <[EMAIL PROTECTED]> wrote: > P. Evans wrote: > > Whenever I try to create a table using innodb, i get a 1266 > warning that the table has been created with myisam instead. I > receive the error both at the mysql command line and using the mysql > query browser. > > Can you please show us the CREATE TABLE command that you are using? > > > > > --------------------------------- > Yahoo! FareChase - Search multiple travel sites in one click.