MySQL启动失败，#1067

MySQL暴力关闭，造成启动失败，Windows日志如下所示：

InnoDB: Attempted to open a previously opened tablespace. Previous tablespace abc/t_hbhb_1440 uses space ID: 4 at filepath: .\abc\t_hbhb_1440.ibd. Cannot open tablespace mysql/slave_master_info which uses space ID: 4 at filepath: .\mysql\slave_master_info.ibd

innodb_force_recovery标识MySQL启动时是否要求强制恢复数据，如果tablespace遭受破坏，需要innodb_force_recovery=1，要求MySQL启动时强制恢复。

innodb_force_recovery = 1

当设置参数值大于0后，可以对表进行select,create,drop操作,但不允许insert,update或者delete操作。数据恢复后，重新置成0

innodb_force_recovery = 0