I have been using MySQL as a windows service successfully on my windows 7 machine for perhaps a year. It has always worked fine. Here are the steps which I think caused it to no longer launch:
1.) My computer ran out of battery power and shut down automatically
while the MySQL windows service was running.
2.) When I tried to restart the computer, it took a very long time
to restore the windows session. A dos prompt said it was
restoring the windows session, and the fan was running very
3.) After perhaps 10 minutes of this, I turned off the computer
forcibly by using the power switch.
4.) When I rebooted the computer, the dos prompt told me that
the previous attempt to restore the windows session failed,
and asked if I wanted to continue loading windows without
restoring the previous session. I said yes.
5.) When I tried to launch the MySQL windows service, I got the
following dialog box indicating error 1067:
6.) I then tried to load MySQL from cmd.exe in order to see the
error logs, and I got the following output which indicates
that it cannot read/write:
How can I resolve this problem?
Here are the contents of
datadir="C:/ProgramData/MySQL/MySQL Server 5.6/data\"
I then restarted cmd.exe as an administrator per Rolando's advice, and got the following results, which indicate that windows cannot find a previous session for the MySQL service. Then cmd.exe remains hung up indefinitely without returning a user prompt:
I then did both of Rolando's suggestions from his edited response, and got the following results indicating that the log sequence numbers are out of sync with one another, which would seem to be the result of the failed restart of windows.
Below is the result of telling cmd.exe to echo the PATH variable:
Here are results of running
dir on the