MySQL Forums
Forum List  »  InnoDB

innochecksum Error for idbdata
Posted by: Martin Decker
Date: February 09, 2016 05:44AM

Dear Forum,

is there a way to repair this form of corruption:

[root@hostname idbdata]# innochecksum -p 206334 /var/lib/mysql/idbdata/idbdata01 -v -d
file /var/lib/mysql/idbdata/idbdata01 = 3833593856 bytes (233984 pages)...
checking pages in range 206334 to 206334
page 206334: log sequence number: first = 2722042417; second = 0
page 206334 invalid (fails log sequence number check)

We are using innodb_file_per_table, so there should be no user-data in this page.

Can we avoid doing a full mysqldump, recreate databases and re-import?

Best regards,

Options: ReplyQuote

Written By
innochecksum Error for idbdata
February 09, 2016 05:44AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.