UniformServer / SQL-DB corrupt after Shutdown

08.
Januar

If the MySql-Server gets shut down unexpectedly when shutting down Windows for example, InnoDB-tables become corrupted. So by the next Server-Start, they are not accessible anymore. There is a quick solution to overcome this issue.

To repair the corrupted InnoDB-tables these simple steps are nessecary:

  1. Shut down MySql-Server
  2. In file "\core\mysql\my.ini" add
    [mysqld]
    innodb_force_recovery = 1
  3. Start MySql-Server
  4. Shut down MySql-Server
  5. Disable entry :
    [mysqld]
    innodb_force_recovery = 0
  6. Start MySql-Server


If an unexpected shutdown was the reason, the MySql-Database should be accessible again.

More infos about "innodb_force_recovery" :  https://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html

Zurück zur Übersicht