Mysql问答集

林继 VPS 知识 5,869 共写了636个字 (2006-09-06 10:54:06) 没有评论 打印 扫描二维码 百度未收录

问 1: 在安装phpwind或Discuz时 到第二步,出现了和数据库连接的错误,如下:MySQL Server Error:
The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working ( 1289 ),操作系统为Windows XP SP2,这是什么错误呢?怎么解决?

答:这2个系统都需要mysql支持innodb,但是你的mysql不支持。

Step 1. Stop MySQL service

Step 2. Delete files:

C:\Program Files\MySQL\MySQL Server 5.0\data\ib_logfile*
C:\MySQL Datafiles\ibdata*

Step 3: Restart MySQL service

MySQL InnoDB needs to create both DATA and LOGS at the same time — it says this in the log file output. So if you don't delete both data and log files at the same time when it starts up it will fail to create the InnoDB database files properly and InnoDB will show up as DISABLED rather than DEFAULT (when using “show engines”).

如果觉得我的文章对您有用,请随意赞赏。您的支持将鼓励我继续创作!

发表评论

电子邮件地址不会被公开。 必填项已用*标注

< >