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

Data structure corruption

juaxixjuaxix EntrantInactive User Role Beginner
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:[email protected] 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?
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.