1. Run this as a service (I can run this manually, not problem there)
Error message:
Could not start MySQL on local computer
Error 1067: The process terminated unexpectedly
This could happen for a number of reasons. Most likely the process can't
find the defaults file. If this service is installed, then do:
Mysqld-nt --remove <service_name>
Then do this
Mysqld-nt --install <service_name> --defaults-file=<full path to my.ini
file>
Now edit your my.ini file and make sure the data and base paths point to the
correct locations.
-reggie