After a server crash (Ubuntu 16.04), when I try to start Mysql (Mysql 5.7) using
innodb_force_recovery=0 it doesn't start and error.log shows:
InnoDB: Checksum mismatch in datafile: ./panel_financiero_v2/kpis_analytics.ibd, Space ID:93, Flags: 33. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue. InnoDB: Corrupted page [page id: space=93, page number=0] of datafile './panel_financiero_v2/kpis_analytics.ibd' could not be found in the doublewrite buffer. InnoDB: Tablespace 93 was not found at ./panel_financiero_v2/kpis_analytics.ibd. InnoDB: Set innodb_force_recovery=1 to ignore this and to permanently lose all changes to the tablespace. InnoDB: Cannot continue operation.
I just can start Mysql using
innodb_force_recovery=6 (I can't start Mysql using innodb_force_recovery=1 as the error message advises).
The .ibd and .frm files of the troubled table are in the right directory (no empty files); I even tried (just in case, with no real hope) to delete these two files (moving them to another directory) but it doesn't work neither.
Any way to repair or recover the table (bearing in mind that innodb_force_recovery=6 starts Mysql in read-only mode and I even can't create a new table)? Any way, at least, to start mysql normally (with
innodb_force_recovery=0) even losing the information of that troubled table?