谁解释一下是怎么回事?

[xayzmb]

版本:5.0.21
执行
alter table T_Name type = innodb;
出现错误提示:
ERROR 1289 (HY000): The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working

[xayzmb]

是数据库安装有问题吗?
我在另一台机子上操作正常呀

[xayzmb]

执行下面的操作也不行
create table T(
n varchar(10) not null default '')
type = innodb

总之
不能建立type = innodb 格式的表

[hy2003fly]

就是你装mysql的时候选了不支持事务,查看支持的表类型可以用命令：
mysql> show engines\G
*************************** 1. row ***************************
Engine: MyISAM
Support: DEFAULT
Comment: Default engine as of MySQL 3.23 with great performance
*************************** 2. row ***************************
Engine: MEMORY
Support: YES
Comment: Hash based, stored in memory, useful for temporary tables
*************************** 3. row ***************************
Engine: InnoDB
Support: YES
Comment: Supports transactions, row-level locking, and foreign keys
*************************** 4. row ***************************
Engine: BerkeleyDB
Support: NO
Comment: Supports transactions and page-level locking
*************************** 5. row ***************************
Engine: BLACKHOLE
Support: NO
Comment: /dev/null storage engine (anything you write to it disappears)
*************************** 6. row ***************************
Engine: EXAMPLE
Support: NO
Comment: Example storage engine
*************************** 7. row ***************************
Engine: ARCHIVE
Support: YES
Comment: Archive storage engine
*************************** 8. row ***************************
Engine: CSV
Support: NO
Comment: CSV storage engine
*************************** 9. row ***************************
Engine: ndbcluster
Support: NO
Comment: Clustered, fault-tolerant, memory-based tables
*************************** 10. row ***************************
Engine: FEDERATED
Support: NO
Comment: Federated MySQL storage engine
*************************** 11. row ***************************
Engine: MRG_MYISAM
Support: YES
Comment: Collection of identical MyISAM tables
*************************** 12. row ***************************
Engine: ISAM
Support: NO
Comment: Obsolete storage engine
12 rows in set (0.00 sec)

[jzhaohua]

ALTER TABLE T_Name ENGINE = InnoDB;

[xayzmb]

请问:hy2003fly()
如何修改?
安装的时候注意什么?

[XqYuan]

看配置文件的这一行是否被注释掉了
#skip-innodb