XP下安装MySQL失败: 版本:mysql-essential-5.0.67-win32.msi 错误信息: 081127 17:02:06 InnoDB: Error: unable to create temporary file; errno: 9
081127 17:02:06 [ERROR] Default storage engine (InnoDB) is not available
081127 17:02:06 [ERROR] Aborting 删除后重新安装了多次,无法解决! 把default-storage-engine=INNODB改为default-storage-engine=MyISAM就OK了 当时目前工作上必须设置为INNODB!向各路神仙求救,谢谢!
081127 17:02:06 [ERROR] Default storage engine (InnoDB) is not available
081127 17:02:06 [ERROR] Aborting 删除后重新安装了多次,无法解决! 把default-storage-engine=INNODB改为default-storage-engine=MyISAM就OK了 当时目前工作上必须设置为INNODB!向各路神仙求救,谢谢!
mysql>show engines;
+------------+---------+----------------------------------------------------------------+--------------+-----+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+------------+---------+----------------------------------------------------------------+--------------+-----+------------+
| EXAMPLE | YES | Example storage engine | NO | NO | NO |
| CSV | YES | CSV storage engine | NO | NO | NO |
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| InnoDB | YES | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
| FEDERATED | YES | Federated MySQL storage engine | NO | NO | NO |
+------------+---------+----------------------------------------------------------------+--------------+-----+------------+
9 rows in set (0.00 sec)
解决方法:
1。删除在MySQL安装目录下的Data目录中的
ib_logfile0
ib_logfile1
2。找到在配置MySQL服务器时指定的InfoDB目录删除掉
ibdata1
3。重新启动MySQL的Service
安装后,根本没有生成以下文件,只有一个l00110060.err文件
ib_logfile0
ib_logfile1
ibdata1
GOOGLE一下吧。
http://www.google.cn/search?hl=zh-CN&newwindow=1&q=%5BERROR%5D+Default+storage+engine+%28InnoDB%29+is+not+available&meta=&aq=f&oq=