朋友一次把mysql从A目录移动到B目录,结果导致innodb出错,部分文件被损坏。
error:140725 11:02:11 InnoDB: Error: page 51134 log sequence number 975290089
InnoDB: is in the future! Current system log sequence number 282944.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html
InnoDB: for more information.
140725 11:02:11 InnoDB: Error: page 51135 log sequence number 975322208
InnoDB: is in the future! Current system log sequence number 282944.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html
InnoDB: for more information.
InnoDB: A new raw disk partition was initialized or
InnoDB: innodb_force_recovery is on: we do not allow
InnoDB: database modifications by the user. Shut down
InnoDB: mysqld and edit my.cnf so that newraw is replaced
InnoDB: with raw, and innodb_force_... is removed.
修复:http://dev.mysql.com/doc/refman/5.0/en/forcing-innodb-recovery.html
innodb_force_recovery = 2
mysqldump -uroot -A |gzip > mysql.$(date +%F).tar.gz
重新初始化mysql导入数据
阅读(1867) | 评论(0) | 转发(0) |