MySQL 访问某数据 crash

症状: mysqldump 导出数据或者访问某张表的或者某条数据的时候 mysql 直接挂了.
日志如下:
InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 26400.
InnoDB: You may have to recover from a backup.
120217 15:45:53 InnoDB: Page dump in ascii and hex （16384 bytes）:
len 16384; hex a922822af0c7bcef6d93dadcf4f63e8331d51e7a490667defbefxxxx..................
InnoDB: End of page dump f 6 PE a r zx3120217 15:45:53 InnoDB: Page checksum 3458627726, prior-to-4.0.14-form checksum 796906866
InnoDB: stored checksum 2837611050, prior-to-4.0.14-form stored checksum 2410301789
InnoDB: Page lsn 836050554 1225156574, low 4 bytes of lsn at page end 2266014174
InnoDB: Page number （if stored to page already） 4039621871,
InnoDB: space id （if created with >= MySQL-4.1.1 and stored already） 4222022822
InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 26400.
InnoDB: You may have to recover from a backup.
InnoDB: It is also possible that your operating
InnoDB: system has corrupted its own file cache
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 table for corruption.
InnoDB: See also http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
InnoDB: Ending processing because of a corrupt database page.
解决: 具体原因不明参考文档:http://cgaolei.iteye.com/blog/412157
http://space.itpub.net/94384/viewspace-604185 首先D:cn.tsoft.systemmysql5.1.37in>mysqlcheck -uroot -pxxxx -P3306 --all-database 定位哪张表出了问题
执行结果如下:
tech_soft_drp_361new.pos_tradebill_cashredeem_item OK
mysqlcheck: Got error: 2013: Lost connection to MySQL server during query when e
xecuting "CHECK TABLE ... " 由tech_soft_drp_361new.pos_tradebill_cashredeem_item 知道下一张表是 pos_tradebill_item 将my.ini 里边的#innodb_force_recovery=1 #号去掉重启mysql服务然后将pos_tradebill_item 数据导出到文件（导出的时候注意导出数据的条数是否正确！）（记录select count（*） from pos_tradebill_item 与导出的条数对比）找到pos_tradebill_item的建表语句. 删除pos_tradebill_item表重建pos_tradebill_item表. 导入pos_tradebill_item数据（导入数据的时候将innodb_force_recovery=1重新加上#号. innodb_force_recovery=1模式不支持写） SUSE Linux 11 开机自动启动 Oracle 数据库Oracle sqlldr导入以回车和回车换行字符结尾的文本相关资讯 MySQL数据库教程

MySQL 处理非法数据（04/09/2013 08:06:28）
MySQL关于timestamp和mysqldump的（12/16/2012 13:25:41）
MySQL保证数据完整性（12/16/2012 12:00:35）

ERROR 1130: mysql 1130连接错误的（12/16/2012 13:29:08）
MySQL数据库教程:管理数据库和表（（12/16/2012 12:47:02）
MySQL快速插入大批量数据存储过程（11/05/2012 19:04:04）

本文评论查看全部评论（0）