MySQL Forums
Forum List  »  Install & Repo

Re: MySQL Service Will Not Start / Windows Server 2012
Posted by: Peter Brawley
Date: September 02, 2020 11:44AM

Quote

a way to copy and paste the errors I am receiving up here. Is there a way to paste code in this message box?

Ordinary copy & paste. To preserve text formatting, use BBCode tags.

Unfortunately this is Windows, so much in https://dev.mysql.com/doc/refman/8.0/en/crashing.html may be difficult to apply, but you need to scan it for anything that looks relevant.

Immediately ... copy the entire datadir as is to a backup location so you have a base case to return to in case repair attempts go sideways. Check my.ini for innodb_data_file_path and innodb_data_home_dir settings outside <datadir>; if they're present, you need to copy those locations too.

Now, backup copies in place, since the crash reports says "Log scan progressed past the checkpoint ...", delete ib_logfile* and try your console start cmd again so InnoDB can rebuild those logs, and let's see what MySQL says.

Finally, why aren't we seeing what the mysql error log reports for the time just before, and at the time when, these crashes first occurred? The error log is named <machinename>.log in C:\ProgramData\MySQL\MySQL Server 5.6\data. There should be stacktraces there of the original problem.



Edited 1 time(s). Last edit at 09/02/2020 11:46AM by Peter Brawley.

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.