【已解决】[ERROR] Unknown/unsupported table type: INNOD

Redshadows

各位好，我是个mysql的小菜鸟。

我已经安装了mysql, mysql-devel, mysql-server。

本来可以正常打开mysql，不过为了将INNODB设置为默认，我在配置文件里添加了default-storage-engine=INNODB。

关闭mysql而后再打开就发现失败了：附上配置文件内容和日志内容，希望各位帮我看看问题，我已经google过了，问题和google上得到的不太一样。

[mysqld]
default-storage-engine=INNODB
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

未添加default-storage-engine=INNODB时，正常打开：
120804 11:25:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120804 11:25:26  InnoDB: Initializing buffer pool, size = 8.0M
120804 11:25:26  InnoDB: Completed initialization of buffer pool
120804 11:25:26  InnoDB: Started; log sequence number 0 44233
120804 11:25:26 [Note] Event Scheduler: Loaded 0 events
120804 11:25:26 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.56'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution


添加default-storage-engine=INNODB后的出错情况：
120804 11:00:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120804 11:00:53  InnoDB: Initializing buffer pool, size = 8.0M
120804 11:00:53  InnoDB: Completed initialization of buffer pool
120804 11:00:54  InnoDB: Started; log sequence number 0 44233
120804 11:00:54 [ERROR] Unknown/unsupported table type: INNOD
120804 11:00:54 [ERROR] Aborting

感激不尽~

Redshadows

问题解决。

进入/var/lib/mysql，然后rm ib*。