MySQL Forums
Forum List  »  Data Recovery

Index corruption with import tablespace
Posted by: Marcel van Brakel
Date: May 28, 2024 08:23AM

Due to some data loss after a misplaced truncate table, I tried to restore an .idb file using the following procedure:

alter table x discard tablespace
replaced the x.idb file with one from our veaam backup
alter table x import tablespace

but this gives me the message:

Error Code: 1817. Index corrupt: Externally stored column(52) has a reference length of 3 in the cluster index PRIMARY

The column 52 is a column of type longtext.

This is innodb running on a Windows server.

Anyone have an idea of how to proceed? Or another method of restoring the content of the .idb file?

Options: ReplyQuote


Subject
Views
Written By
Posted
Index corruption with import tablespace
415
May 28, 2024 08:23AM


Sorry, only registered users may post in this forum.

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.