It seems that whenever I restart my Windows 7 64bit box MySQL gets corrupted.

I just wanted to make this bug known as it's a serious issue. Are there any special settings I need to setup (task scheduler) to prevent this from happening?

Is there a way to inform Windows to shutdown MySQL?


MySQL can run as a service and I hope that windows is stopping the services gracefully or you are likely to have more problems outside of MySQL. If you want to be careful, stop the service by hand. This should allow MySQL to flush all buffers before stopping. I would guess from your comment that you're getting corruption that you are using the MyISAM engine; my advice would be to migrate your tables to the InnoDB engine to make best use of the durability of the engine. In the event of a crash or ungraceful shutdown, MySQL will better recover data.

protected by Community Mar 25 '15 at 23:02

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.