Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 Unexpetedlly.

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?

Thanks

share|improve this question

migrated from stackoverflow.com 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
1  
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

1 Answer 1

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

Thanks

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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