WAMP服务器保持脱机状态. MySQL服务未启动“无法启动wampmysqld64服务-错误1067". [英] WAMP Server stays offline. MySQL service not starting "could not start the wampmysqld64 service - error 1067"

问题描述

我花了几个小时尝试使服务器第一次运行，尝试了许多在线发布的解决方案，但是都没有成功.

I have spent hours trying to get the server running (for the first time), trying many solutions posted online, but to no success.

首次安装(Win 7 x64)，仍然无法正常运行(服务器离线).如果我查看服务，启动/继续服务将保持绿色:

First time install (Win 7 x64), light remains orage (server offline). If I look at service, the start/resume service remains green:

如果我进入服务并尝试启动wampmysqld64服务，则会收到此错误消息:

If I go in services and try start wampmysqld64 service I get this error message:

这是事件查看器应用程序日志(WAMP mysql日志为空):

Here is the Event Viewer Application log (the WAMP mysql log is empty):

Error   11/09/2015 09:04:22 MySQL   100 None Aborting
Error   11/09/2015 09:04:22 MySQL   100 None Unknown/unsupported storage engine: InnoDB
Error   11/09/2015 09:04:22 MySQL   100 None Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Error   11/09/2015 09:04:22 MySQL   100 None Plugin 'InnoDB' init function returned error.
Error   11/09/2015 09:04:22 MySQL   100 None InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
Error   11/09/2015 09:04:22 MySQL   100 None InnoDB: space header page consists of zero bytes in data file .\ibdata1
Warning 11/09/2015 09:04:22 MySQL   100 None InnoDB: Doublewrite does not have page_no=0 of space: 0

我没有删除/删除任何文件，但是由于空间限制，我确实在我的D驱动器(C上的OS)上安装了WAMP服务器.

I haven't removed/deleted any files, but I did install WAMP server on my D drive (OS on C) due to space limitations).

推荐答案

在D:驱动器上安装WAMPServer很好.

Installing WAMPServer on the D: drive is just fine.

可能这些文件已损坏，因此请尝试将其删除.

Possibly somehow these files have been corrupted so try deleting them.

停止WAMPServer

Stop WAMPServer

删除这些文件，因为这是初始安装，因此它们中将没有任何数据，并且WAMPServer的重启将导致MYSQL重新创建它们.

Delete these files, as this is an initial install they will not have any data in them and the restart of WAMPServer should cause MYSQL to re-create them.

\wamp\bin\mysql\mysql5.6.17\data\ib_logfile0
\wamp\bin\mysql\mysql5.6.17\data\ib_logfile1
\wamp\bin\mysql\mysql5.6.17\data\ibdata1

现在有一个小错误修复:编辑\wamp\bin\mysql\mysql5.6.17\my.ini 找到部分标记[wampmysqld]并将其更改为[wampmysqld64]

Now for a little bug fix: Edit \wamp\bin\mysql\mysql5.6.17\my.ini Find the section marker [wampmysqld] and change it to [wampmysqld64]

保存my.ini

重新启动WAMPServer

Restart WAMPServer

此外，如果您的内存不足，则将此参数添加到[wampmysqld64]内的my.ini文件中将减少MYSQL内存需求.更高版本的MYSQL似乎使用了大量的内存(半个演出)，其中很多是用于MYISAM文件的table_definition_cache，这会将其减少到合理的程度，并且不会影响您对MYISAM文件的使用.

Also if you are a little short of memory adding this parameter to the my.ini file inside the [wampmysqld64] will reduce the MYSQL memory requirement. Later versions of MYSQL seem to use a hugh amounts of memory ( half a gig ) lots of which is the table_definition_cache for MYISAM files, this will reduce it to something sensible and not effect your use of MYISAM files.

[wampmysqld64]
table_definition_cache = 600

这篇关于WAMP服务器保持脱机状态. MySQL服务未启动“无法启动wampmysqld64服务-错误1067".的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！