MYSQL Database/Table recovery from frm and ibd file

[Tabbin]

Hey, I have a db I need the tables from, I have the ibd and frm files for them, if you can recover the tables from this, I'm willing to pay a l lot.


If you dont know what you are talking about please dont message me / post here

 

[MTG]

Did you try google?

 

[Tabbin]

Did you try google?

I'm looking for someone to do it,

"If you dont know what you are talking about please dont message me / post here "

 

[Samuel]

How much you paying?

 

[SpeedyQuickCoding]

InnoDB needs the ib_log files for data recovery, but it also needs the ibdata1 file which contains the data dictionary and sometimes contains pending data for the tables. So unless you have those, I don't think that it's possible. You can't just move .ibd files around without the InnoDB data dictionary, and the data dictionary must match the table id found inside the .ibd file.

However, you could try the following.

"mysqlfrm --diagnostic myfile.frm" and see if that will fix it however, A warning is issued indicating that InnoDB will attempt to import the file without schema verification.

 

[Tabbin]

How much you paying?

I'm not sure, as I dont know how long it will take. Also PP only.

InnoDB needs the ib_log files for data recovery, but it also needs the ibdata1 file which contains the data dictionary and sometimes contains pending data for the tables. So unless you have those, I don't think that it's possible. You can't just move .ibd files around without the InnoDB data dictionary, and the data dictionary must match the table id found inside the .ibd file.

However, you could try the following.

"mysqlfrm --diagnostic myfile.frm" and see if that will fix it however, A warning is issued indicating that InnoDB will attempt to import the file without schema verification.

Thanks for this information, that thing didn't do anything to fix it.

Samuel I don't have the ib_log files, I'm not sure if you need them, like this guy said.

 

[SpeedyQuickCoding]

Actually, I think I have found a way to do this without the ib_log files, add me on skype @ speedy.quick.coding

 

[Samuel]

Also PP only.

Good luck, I'm out.