MySQL: “Error 1067: The process terminated unexpectedly”

One of my software client just called and say “The application is not working after antivirus scan”. Then I turn on my laptop and do a remote desktop to the server. Turns out the error is caused by inactive MySQL service.

I tried to start it but I get the error “Error 1067: The process terminated unexpectedly”. Since this is not a fresh install of MySQL, so it can not be misconfiguration in “my.ini” file. My software client’s computer has this configuration:

• Running Windows 7 x64
• MySQL Community Server 5.1.30
• .NET Framework 4.0
• Avast Antivirus Free Edition

So this is my solution to recover the service:

1. Go to <install directory>:\ProgramData\MySQL\MySQL Server 5.1\data
2. Backup the “ib_logfile0” and “ib_logfile1” (in case you want to roll back)
3. Delete both above files.
4. Start the MySQL service, it will automatically re-create both previous files.
5. Enjoy your MySQL service.

Hope this helps.