操作系统windows Server 2003
安装mysql
错误日志显示101019 13:49:44 [Note] Plugin 'FEDERATED' is disabled.
101019 13:49:44 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html
InnoDB: File name \xampp\mysql\data\ib_logfile0
InnoDB: File operation call: 'aio read'.
InnoDB: Cannot continue operation.哪位大侠路过给瞧瞧
安装mysql
错误日志显示101019 13:49:44 [Note] Plugin 'FEDERATED' is disabled.
101019 13:49:44 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html
InnoDB: File name \xampp\mysql\data\ib_logfile0
InnoDB: File operation call: 'aio read'.
InnoDB: Cannot continue operation.哪位大侠路过给瞧瞧
可能是文件系统兼容问题。ERROR_INVALID_PARAMETER
87 (0x57)
The parameter is incorrect.
错误症状:Could not start the service=MySQL:error 0 (运行config wizard 后启动服务显示)
安装环境:XP
Log分析:可以在data文件夹中找到***.err的mysql日志文件,出现的启动错误描述日志记录: 090803 8:51:54 [Note] Plugin 'FEDERATED' is disabled.
090803 8:51:55 InnoDB: Error: unable to create temporary file; errno: 2
090803 8:51:55 [ERROR] Plugin 'InnoDB' init function returned error.
090803 8:51:55 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
090803 8:51:55 [ERROR] Unknown/unsupported table type: INNODB
090803 8:51:55 [ERROR] Aborting 解决原因:MySQL的config wizard向导生成my.ini漏掉一条配置tmpdir的目录
解决办法:在my.ini中增加一行
tmpdir="D:/Program Files/MySQL/MySQL Server 5.1/DataFiles/Data/"
(目录可以随意)
个人说明:这种错误为按照官方标准安装出现错误,期待这个“小”bug下一版本的修复,这个小错误会导致无论重装多少遍都不会得到解决,还会产生一种自己太笨,连个MySQL都装不上的不好想法
这个我也是网上帮你找的,希望对你有用处~~~~
my.ini:
innodb_flush_method=normal试下看吧