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中如何从prepare语句获取的单行单列结果存储到一个变量?
- mysql乱码问题
- 触发器中STRCMP函数问题
- mysqldump 。。dump了几天了。。 0.0~
- MySQL命令行无法启动
- mysql show processlist如何判断哪个sql语句比较占时间?
- 有谁能提供linux下的MySQL 3.23.49 的jdbc驱动?
- 通过什么方式可以获得select get_lock('rec', 1)的结果值?
- 阿里的开源中间件Cobar的应用情况
- 一个关于Group by与外键选择数据的问题
- VC 中用MYSQL C Api 访问MySQL 数据库服务器
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=