- Create a backup of all current MySQL data and databases at C:\ProgramData\MySQL\MySQL Server n.n\data
- Open the C:\ProgramData\MySQL\MySQL Server n.n\my.ini file.
- Add the following line into the [MySQLD] section:
innodb_force_recovery = 1
skip-grant-tables - Try to start MySQL.
- Stop MySQL service.
- Remove the line innodb_force_recovery from my.ini file and start MySQL.
Alternative
- Open: C:\ProgramData\MySQL\MySQL Server n.n\data
- Delete ib_logfile0 & ib_logfile1
- Start MySQL Service