Not the answer you need?
Register and ask your own question!

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

havenahavena EntrantInactive User Role Beginner
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 http://www.mysqlperformanceblog.com/...sql-utilities/)


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

Comments

  • revinrevin Contributor Current User Role Beginner
    Its likely the headers on the IBD file has been corrupted. Are you importing to the same version as the one where it crashed?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.