错误日志报以下错误(片断):
InnoDB: Database page corruption on disk or a failed
InnoDB:file read of page 5.
InnoDB: You may have to recover from a backup.2020-06-19 17:22:00 7f11c48e1720 InnoDB: Page dump in ascii and hex (16384bytes):
len16384; hex 7478d078000000050000000000000000000000000f001f4d000700000000000000000000000000000000001b4000000000000000000200f20000000000000006000000000000002d000000000000002e000000000000002f0000000000000030000000000...
InnoDB: End of page dump2020-06-19 17:22:00 7f11c48e1720 InnoDB: uncompressed page, stored checksum in field1 1954074744, calculated checksums for field1: crc32 993334256, innodb 2046145943, none 3735928559, stored checksum in field2 1139795846, calculated checksums for field2: crc32 993334256, innodb 1606613742, none 3735928559, page LSN 0 254222157, low 4 bytes of LSN at page end 254221236, page number (if stored to page already) 5, space id (if created with >= MySQL-4.1.1 and stored already) 0InnoDB: Page may be a transaction system page
InnoDB: Database page corruption on disk or a failed
InnoDB:file read of page 5.
InnoDB: You may have to recover from a backup.
InnoDB: It is also possible that your operating
InnoDB: system has corrupted its ownfilecache
InnoDB: and rebooting your computer removes the
InnoDB: error.
InnoDB: If the corrupt page is an index page
InnoDB: you can also try to fix the corruption
InnoDB: by dumping, dropping, and reimporting
InnoDB: the corrupt table. You can use CHECK
InnoDB: TABLE to scan your tableforcorruption.
InnoDB: See also http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
InnoDB: Ending processing because of a corrupt database page.
* 这是由于系统崩溃或重启导致MYSQL恢复文件损坏而无法启动
解决办法:
1、编辑my.cnf(vim /etc/my.cnf),添加如下参数:
[mysqld]
innodb_force_recovery= 1
2、再次启动mysql(此时可以启动成功,启动SHELL脚本示例如下:)
service mysql start
3、使用mysqldump备份数据库(示例SHELL脚本如下:)
mysqldump -uroot -proot dbName>db.sql
所有非系统数据库都得备份
4、删除备份的数据库(所有非系统数据库,示例SQL脚本如下:)
drop database dbName
5、关闭(注释)第一步的选项(参数),编辑my.cnf(vim /etc/my.cnf)
6、重新启动数据库(此时启动成功,代表恢复正常了)
7、恢复备份的数据库(示例脚本如下)
create databasedbName;usecdbName;
source/opt/db.sql;
* 至此已完成数据库的修复。总结一下,其实很简单:打开参数 > 启动数据库 > 备份数据 > 关闭参数 > 重启数据库 > 恢复数据