GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

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

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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

  • #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?
    Our documentation has a lot of answers about common questions on Percona software, have you checked there before posting that question here? http://www.percona.com/forums/core/i...lies/smile.png

    Join us at the annual Percona Live MySQL Users Conference - http://www.percona.com/live/mysql-conference-2014/

    Comment

    Working...
    X