1

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?

1

1 Answer 1

1

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.

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