Question

xampp的mysql启动不起来，错误日志里面有以下记录，怎么解决？？？

121020 22:38:50 [Note] Plugin 'FEDERATED' is disabled.
121020 22:38:50 InnoDB: The InnoDB memory heap is disabled
121020 22:38:50 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121020 22:38:50 InnoDB: Compressed tables use zlib 1.2.3
121020 22:38:50 InnoDB: Error: unable to create temporary file; errno: 2
121020 22:38:50 [ERROR] Plugin 'InnoDB' init function returned error.
121020 22:38:50 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
121020 22:38:50 [ERROR] Unknown/unsupported storage engine: InnoDB
121020 22:38:50 [ERROR] Aborting

121020 22:38:50 [Note] d:\xampp\mysql\bin\mysqld.exe: Shutdown complete

Answer 1

看错误Error: unable to create temporary file; errno: 2，应该是不能创建临时文件引起的。
试试手动创建个临时目录然后在配置文件中显式指定： tmpdir="e:\tmp"

追问

临时文件的名称是什么？

追答

实际就是配置个临时目录，随意命名创建即可（如e:\mysql_tmp），然后在配置中 my.ini 的[mysqld]中配置 tmpdir="e:\mysql_tmp"