mysql中怎么配置innodb引擎?

Question

winxp 下,mysql5.0mysql> 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     | DISABLED | Supports transactions, row-level locking, and foreign keys     |
| BerkeleyDB | NO       | Supports transactions and page-level locking                   |
| BLACKHOLE  | YES      | /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  | DISABLED | Federated MySQL storage engine                                 |
| MRG_MYISAM | YES      | Collection of identical MyISAM tables                          |
| ISAM       | NO       | Obsolete storage engine                                        |
+------------+----------+----------------------------------------------------------------+这里InnoDB是DISABLED 的,怎么配置让他支持呢?这里我已经放开注释了:
# Uncomment the following if you are using InnoDB tables

Answer 1

#skip-innodbmy.ini 文件，把这个#去掉，然后重启mysql

Answer 2

#*** INNODB Specific options ***
# Use this option if you have a MySQL server with InnoDB support enabled
# but you do not plan to use it. This will save memory and disk space
# and speed up some things.
#skip-innodb

Answer 3

楼上两位答错,skip-innodb 显然是不要用innodb.
找到方法是:安装的时候就选transaction的方式.把配置文件里面的
# Uncomment the following if you are using InnoDB tables 这里注释放开