MySQL 重启后数据出问题导致服务不可用

一台MySQL slave 由于需要把服务重启了一次,用ps -ef  |grep mysql时发现没有进程,看日志发现

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.1/en/forcing-recovery.html
InnoDB: about forcing recovery.
InnoDB: Ending processing because of a corrupt database page.
100317 05:26:54 mysqld_safe Number of processes running now: 0
100317 05:26:54 mysqld_safe mysqld restarted

在my.cnf添加
innodb_force_recovery = 4

后仍然是这个错误,一时没有找到相关解决方法,只能从另一台slave把mysql目录copy到这台机器重新同步

Post a Comment