# percona data recovery tool for innodb 0.5 page\_parser

**URL:** <https://forums.percona.com/t/percona-data-recovery-tool-for-innodb-0-5-page-parser/5044>\
**Category:** Other MySQL® Questions\
**Created:** [August 23, 2016, 3:57pm UTC](https://forums.percona.com/t/percona-data-recovery-tool-for-innodb-0-5-page-parser/5044 "2016-08-23T15:57:50Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![bayar](https://avatars.discourse-cdn.com/v4/letter/b/6bbea6/32.png) [@bayar](https://forums.percona.com/u/bayar)\
**Post date:** [August 23, 2016, 3:57pm UTC](https://forums.percona.com/t/percona-data-recovery-tool-for-innodb-0-5-page-parser/5044/1 "2016-08-23T15:57:50Z")

</div>

I used MySQL 5.6, InnoDB Engine, with innodb\_file\_per\_table=1  
I know that every table stores its data in .ibd file but now I lost .ibd file for two tables  
now I’m using percona-data-recovery-tool-for-innodb 0.5 and I do have a structure for table and also ibdata1 file, now i managed to recover some data but the column next to the primary key is empty and that’s the most important column, and every other columns are full of correct data  
my question is that does that version 0.5 supports MySQL 5.6, or can I get only specific columns from constraints\_parser, page\_parser

---

<div class="post-metadata">

**Author:** ![laudares](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/laudares/32/10_2.png) [@laudares](https://forums.percona.com/u/laudares)\
**Post date:** [August 23, 2016, 4:18pm UTC](https://forums.percona.com/t/percona-data-recovery-tool-for-innodb-0-5-page-parser/5044/2 "2016-08-23T16:18:53Z")

</div>

Hi Bayar,

can you post the structure of your table, a “SHOW CREATE TABLE \<table\_name\>\G” ?  
I believe that name field should be a VARCHAR and thus the tool should work with it just fine, however it might not be able to restore everything.

---

<div class="post-metadata">

**Author:** ![revin](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/revin/32/824_2.png) [@revin](https://forums.percona.com/u/revin)\
**Post date:** [August 24, 2016, 11:16pm UTC](https://forums.percona.com/t/percona-data-recovery-tool-for-innodb-0-5-page-parser/5044/3 "2016-08-24T23:16:04Z")

</div>

What was the table definition and which column was missing. If this a BLOB column you need to specify the path to the external pages to actually parse them.  
-b – Directory where external pages can be found. Usually it is pages-XXX/FIL\_PAGE\_TYPE\_BLOB/

---

<div class="post-metadata">

**Author:** ![bayar](https://avatars.discourse-cdn.com/v4/letter/b/6bbea6/32.png) [@bayar](https://forums.percona.com/u/bayar)\
**Post date:** [August 26, 2016, 7:51am UTC](https://forums.percona.com/t/percona-data-recovery-tool-for-innodb-0-5-page-parser/5044/4 "2016-08-26T07:51:32Z")

</div>

> [@laudares;45644](#):
>
> Hi Bayar,
> 
> can you post the structure of your table, a “SHOW CREATE TABLE \<table\_name\>\G” ?  
> I believe that name field should be a VARCHAR and thus the tool should work with it just fine, however it might not be able to restore everything.

here’s my table structure  
create table customers (  
id int auto\_increment primary key,  
name varchar(120) unicode not null,  
phone varchar(32),  
location varchar(255),  
isDeptOn int not null,  
funds decimal(9, 2) not null,  
mandob\_id int not null,  
alert\_days int,  
maxDebt decimal(9, 2),  
index (name),  
index (mandob\_id)  
);

it restores location which is also varchar but the second column it doesn’t recover it and don’t know why