Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am having an issue on my server. I am running MySQL on Windows Server 2008 R2. I have done some changes to my.ini file so I had to restart the MySQL for the changes to take effect. and when I went to services and tried to start MySQL56 windows gives me this error:

Windows could not start the MySQL56 service on Local Computer. Error 1067: The process terminated Unexpectedly.

I tried rebooting my server and that did not work. I restored the changes that I made to my.ini and that did not work.

What can I do to bring MySQL back up?

share|improve this question

migrated from Jun 13 '13 at 17:18

This question came from our site for professional and enthusiast programmers.

Anything informative in your logs? – eggyal Jun 13 '13 at 16:18
where would i find the logs for mysql? – Mike Jun 13 '13 at 16:21
Depends. Read this. – eggyal Jun 13 '13 at 16:24
here is an error InnoDB: Attempted to open a previously opened tablespace – Mike Jun 13 '13 at 16:55

Found the problem. The Log file was full. I had open the my.ini file and increase the innodb_log_file_size variable.


share|improve this answer
Yes, the default log file size is now 50MB instead of the old 5MB. If you were running with a log file size of 5MB, this was probably a bad bottleneck for you! – Bill Karwin Jun 13 '13 at 17:23

I had the same issue the other day. Try this, it should work!

  1. Right click on MySQL Notifier -> Actions -> Manage Monitored Items

  2. Highlight the MySQL56 entry and click the delete button

  3. Click the add button -> windows service
  4. Scroll down and look for MySQL56
  5. Highlight it and click ok
share|improve this answer

protected by Community Sep 22 '15 at 17:42

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.