recover .ibd - Cannot reset LSNs in table Data structure corruption

MySQL & MariaDB Other MySQL® Questions
1

Hello,

after a server crash, i backup all mysql file. But i was unable to start mysql with this backup on a fresh install (ibdata1 checksum error)

so, i try to recover innodb file from ibd (i follow this [URL=“http://www.mysqlperformanceblog.com/2014/01/02/recover-table-structure-frm-files-mysql-utilities/”]http://www.mysqlperformanceblog.com/...sql-utilities/[/URL])

but for some table i get this error on last step when i try to import tablespace :

#1815 - Internal error: Cannot reset LSNs in table ‘“data”.“table”’ : Data structure corruption

can someone help me?

Best regards

1 Like
2

Its likely the headers on the IBD file has been corrupted. Are you importing to the same version as the one where it crashed?

1 Like
3

Got the same error because the *.ibd and *.cfg were owned by root. Make sure to chown mysql:mysql them.

Maybe it still helps somebody :slight_smile:

1 Like