MySql：Windows Coluld无法在本地计算机上启动mySql服务。错误1067进程意外终止

问题描述：

我在Windows 7上使用mysql server 5.5。突然MySql Server停止工作。当我从服务运行MySql服务时，它显示此错误 Windows Coluld无法在本地计算机上启动mySql服务。 错误1067流程意外终止。 

经过大量搜索后我从Mysql数据文件夹中打开错误文件，它显示了这个 -

I am using mysql server 5.5 on windows 7. Suddenly MySql Server stops working. When i going to run MySql Service from Services it show this error "Windows Coluld not start the mySql Service on local computer. Error 1067 The process terminated unexpectedly". 
After A lot of searching i open the error file from Mysql Data Folder it shows this-

><br>
Error File<br><br>
150926 12:09:50 [Note] Plugin 'FEDERATED' is disabled.
<br>
150926 12:09:50 InnoDB: The InnoDB memory heap is disabled<br>
150926 12:09:50 InnoDB: Mutexes and rw_locks use Windows interlocked functions<br>
150926 12:09:50 InnoDB: Compressed tables use zlib 1.2.3<br>
150926 12:09:50 InnoDB: Initializing buffer pool, size = 106.0M<br>
150926 12:09:50 InnoDB: Completed initialization of buffer pool<br>
150926 12:09:50 InnoDB: highest supported file format is Barracuda.<br>
InnoDB: The log sequence number in ibdata files does not match<br>
InnoDB: the log sequence number in the ib_logfiles!<br>
150926 12:09:50  InnoDB: Database was not shut down normally!<br>
InnoDB: Starting crash recovery.<br>
InnoDB: Reading tablespace information from the .ibd files...<br>
InnoDB: Restoring possible half-written data pages from the doublewrite<br>
InnoDB: buffer...<br>
150926 12:09:58  InnoDB: Operating system error number 23 in a file <br>operation.
InnoDB: Some operating system error numbers are described at<br>
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/operating-system-error-<br>codes.html<br>
InnoDB: File name .\ibdata1<br>
InnoDB: File operation call: 'Windows aio'.<br>
InnoDB: Cannot continue operation.<br>
<br><br>

请在这种情况下帮助我...

Please help me in this situation...

答

不完全确定这一点，但看起来数据文件在异常关闭期间已被损坏（也许是powerloss）。换句话说，所有的变化都没有被写到磁盘上。

看起来这是因为这个

Not completely sure about this but it looks like the data file has been damaged during an abnormal shutdown (powerloss perhaps). In other words the chances are all the changes have not been written onto the disk.

It looks like this because of this

InnoDB: Restoring possible half-written data pages from the doublewrite

和系统错误代码（0-499） [ ^ ]是

and the error code 23 on System Error Codes (0-499)[^] is

ERROR_CRC
23 (0x17)
Data error (cyclic redundancy check).

我要尝试的第一件事是将数据库从备份恢复到另一台计算机，看看它是如何工作的。

The first thing I would try is to restore the database from a backup to another computer and see how it works.

MySql：Windows Coluld无法在本地计算机上启动mySql服务。错误1067进程意外终止

相关推荐