Database page corruption on disk or a failed file read of page [page id: space=7558, page number=168

mysql日志报错：

2019-08-28T06:35:11.449650Z 0 [ERROR] InnoDB: Database page corruption on disk or a failed file read of page [page id: space=7558, page number=1561]. You may have to recover from a backup.
2019-08-28T06:35:11.449714Z 0 [Note] InnoDB: Page dump in ascii and hex (16384 bytes):

意思为表或数据库空间损毁
解决方法：
1.将文件my.cnf加上innodb_force_recovery=1，将mysql改为强制启动

innodb_force_recovery=0

2.重启mysql导出报错表，修改innodb_force_recovery=0即可

3.如果mysql表太多找不到损毁的表则在将my.cnf中加入disable-partition-engine-check意思为不要检查损毁的表

disable-partition-engine-check
innodb_force_recovery=0

在mysql日志中将会把损毁的表找到

2019-08-28T06:35:18.218864Z 26 [Note] InnoDB: Table `tjbb`.`operation_snmpwarn` is corrupted. Please drop the table and recreate it

然后用前面的方法导出表，再删除表最后将innodb_force_recovery=0改回来即可
图片共享网站:www.sharepic.vip