InnoDB: Error: unable to create temporary file

最新推荐文章于 2024-12-19 14:30:38 发布

原创最新推荐文章于 2024-12-19 14:30:38 发布 · 1.1w 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql #异常

Mysql 专栏收录该内容

3 篇文章

订阅专栏

本文详细记录了Mysql安装过程中的异常，包括禁用FEDERATED插件和InnoDB错误导致无法创建临时文件的解决方法。通过删除指定路径的ib_logfile0文件，成功解决了安装问题。

记录一个Mysql安装过程中抛的异常：

2013-12-21 09:24:53 4948 [Note] Plugin 'FEDERATED' is disabled.
2013-12-21 09:24:53 4948 [Note] InnoDB: The InnoDB memory heap is disabled
2013-12-21 09:24:53 4948 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-12-21 09:24:53 4948 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-12-21 09:24:53 4948 [Note] InnoDB: Not using CPU crc32 instructions
2013-12-21 09:24:53 15f0  InnoDB: Error: unable to create temporary file; errno: 2
2013-12-21 09:24:53 4948 [ERROR] Plugin 'InnoDB' init function returned error.
2013-12-21 09:24:53 4948 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2013-12-21 09:24:53 4948 [ERROR] Unknown/unsupported storage engine: InnoDB
2013-12-21 09:24:53 4948 [ERROR] Aborting

解决方法：删除F:\Program Files\mysql-5.6.15-win32\data\ib_logfile0