InnoDB: Error: space id and page no stored in the page

vi /etc/my.cnf
innodb_force_recovery=1

service mysql start

Eror can look like this:

InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 139256.
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-innodb-recovery.html
InnoDB: about forcing recovery.
InnoDB: Ending processing because of a corrupt database page.

Leave a Reply

Your email address will not be published. Required fields are marked *