Cant create InnoDB tables

Hi

Ive just installed MySQL from source (5.0.45) but I cant seem to
create any InnoDB tables??

mysql> create table mytable (
-> data varchar(10)
-> ) ENGINE = InnoDB;


mysql> show table status;
+---------+--------+---------+------------+------+----------------
+-------------+-----------------+--------------+-----------
+----------------+---------------------+---------------------
+------------+-------------------+----------+----------------+---------
+
| Name | Engine | Version | Row_format | Rows | Avg_row_length |
Data_length | Max_data_length | Index_length | Data_free |
Auto_increment | Create_time | Update_time |
Check_time | Collation | Checksum | Create_options | Comment |
+---------+--------+---------+------------+------+----------------
+-------------+-----------------+--------------+-----------
+----------------+---------------------+---------------------
+------------+-------------------+----------+----------------+---------
+
| mytable | MyISAM | 10 | Dynamic | 0 | 0
| 0 | 281474976710655 | 1024 | 0 |
NULL | 2007-07-20 10:24:00 | 2007-07-20 10:23:59 | NULL |
latin1_swedish_ci | NULL | | |
+---------+--------+---------+------------+------+----------------
+-------------+-----------------+--------------+-----------
+----------------+---------------------+---------------------
+------------+-------------------+----------+----------------+---------
+
1 row in set (0.00 sec)


What conditions need to be true to be able to create InnoDB tables?
Are there any special build conditions?

Suk <sukesh@zoom.co.uk> wrote:
> Hi
>
> Ive just installed MySQL from source (5.0.45) but I cant seem to
> create any InnoDB tables??
>
> mysql> create table mytable (
> -> data varchar(10)
> -> ) ENGINE = InnoDB;
>
> mysql> show table status;
(was created as MyISAM)

mysql> create table mytable (data varchar(10)) ENGINE = InnoDB;
Query OK, 0 rows affected, 1 warning (0,01 sec)

mysql> show warnings;
+---------+------+-------------------------------------------------+
| Level | Code | Message |
+---------+------+-------------------------------------------------+
| Warning | 1266 | Using storage engine MyISAM for table 'mytable' |
+---------+------+-------------------------------------------------+

mysql> show engines;
+------------+----------+----------------------------------------------------------------+
| Engine | Support | Comment |
+------------+----------+----------------------------------------------------------------+
....
| InnoDB | DISABLED | Supports transactions, row-level locking, and foreign keys |
....

http://dev.mysql.com/doc/refman/5.0/...ate-table.html

"If a storage engine is specified that is not available, MySQL uses the
default engine instead. Normally, this is MyISAM."

> What conditions need to be true to be able to create InnoDB tables?
> Are there any special build conditions?

One can compile MySQL w/o InnoDB. Or just put skip-innodb in my.cnf.



XL
--
Axel Schwenke, Support Engineer, MySQL AB

Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
MySQL User Forums: http://forums.mysql.com/

Axel Schwenke wrote:
> Suk <sukesh@zoom.co.uk> wrote:
>> Hi
>>
>> Ive just installed MySQL from source (5.0.45) but I cant seem to
>> create any InnoDB tables??
>>
>> mysql> create table mytable (
>> -> data varchar(10)
>> -> ) ENGINE = InnoDB;
>>
>> mysql> show table status;
> (was created as MyISAM)
>
> mysql> create table mytable (data varchar(10)) ENGINE = InnoDB;
> Query OK, 0 rows affected, 1 warning (0,01 sec)
>
> mysql> show warnings;
> +---------+------+-------------------------------------------------+
> | Level | Code | Message |
> +---------+------+-------------------------------------------------+
> | Warning | 1266 | Using storage engine MyISAM for table 'mytable' |
> +---------+------+-------------------------------------------------+
>
> mysql> show engines;
> +------------+----------+----------------------------------------------------------------+
> | Engine | Support | Comment |
> +------------+----------+----------------------------------------------------------------+
> ...
> | InnoDB | DISABLED | Supports transactions, row-level locking, and foreign keys |
> ...
>
> http://dev.mysql.com/doc/refman/5.0/...ate-table.html
>
> "If a storage engine is specified that is not available, MySQL uses the
> default engine instead. Normally, this is MyISAM."
>
>> What conditions need to be true to be able to create InnoDB tables?
>> Are there any special build conditions?
>
> One can compile MySQL w/o InnoDB. Or just put skip-innodb in my.cnf.
>
>
>
> XL
> --
> Axel Schwenke, Support Engineer, MySQL AB
>
> Online User Manual: http://dev.mysql.com/doc/refman/5.0/en/
> MySQL User Forums: http://forums.mysql.com/

what do you see when your run this cmd:
show engines;