Remember the MySQL disaster caused by forced shutdown

MySQL version: 5.5

The notebook is dead again, only the screen is alive, it should be the memory disk problem. In short, I opened the MySQL service and forced shutdown, when the computer opened again, the MySQL service failed to start.

First look at the Windows logs, the log prompts some errors, but not specific.

1. Then save the data directory below the main directory (which is the basic information of all the tables), the following Ibdata1 file stores the information, so it needs to be saved.

2. Then reinstall MySQL, here using the MySQL installation software to uninstall and reload, self-installing some information is not completely deleted.

3. Finally copy the data directory back.

4. The database is not the same as before the crash, when only the root user, other users need additional.

Summary: 1. Memory disk software really need to use less, not very stable. 2. Do not arbitrarily force the shutdown, especially when you open MySQL.

Remember the MySQL disaster caused by forced shutdown