# Data structure corruption

**URL:** <https://forums.percona.com/t/data-structure-corruption/3792>\
**Category:** Percona XtraBackup\
**Created:** [October 1, 2014, 7:28am UTC](https://forums.percona.com/t/data-structure-corruption/3792 "2014-10-01T07:28:25Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![juaxix](https://avatars.discourse-cdn.com/v4/letter/j/74df32/32.png) [@juaxix](https://forums.percona.com/u/juaxix)\
**Post date:** [October 1, 2014, 7:28am UTC](https://forums.percona.com/t/data-structure-corruption/3792/1 "2014-10-01T07:28:25Z")

</div>

Hello, I have a Data structure corruption in a table from my database.  
The first thing i did is to get the files from my old database server, but it looks like there is a problem with them.  
I only have mytable.frm and mytable.idb files, no indexes or metadata, but after running  
mysqlfrm --server=root:rootpassword@localhost mysql:,mytable.frm --port=3307  
I got the structure, I have not the original datafile (ibdata1) so I dont know if i will be able to recover the data, i tried with  
ibdconnect -o mysql/data/ibdata1 -f mysql/data/mydb/mytable.ibd -t mytable -d mydb and the results:  
SYS\_INDEXES is updated successfully  
but after going to mysql and running  
alter table mytable discard tablespace;  
(here then did the shutoff mysqld, copy the old mytable.ibd file and did the ibdconnect thing and go on)  
and then:  
alter table mytable import tablespace;  
the same error occurs:  
mysql\> alter table wp\_wp\_pro\_quiz\_question import tablespace;  
“ERROR 1815 (HY000): Internal error: Cannot reset LSNs in table ‘“mydb”.“mytable”’ : Data structure corruption”  
so, what am i doing wrong?
