Sonalkumar sute
Reputation: 2575
restore table structure from idb file, bymistakely deleted frm file
I am using mysql and innodb storage engine, bymistakely I deleted .frm file from application and now have just .ibd file. Not able to restore the table structure as frm file is not there.
Is there any way to get the .frm file back, or how should I restore table without .frm file, I have table structure in .sql file
Any help on this please
Upvotes: 1
Views: 1111
Answers (1)
akuzminsky
Reputation: 2258
On 5.5 there are two ways. Either a fake frm file as ravnur suggested or dump records from the .ibd file with https://github.com/twindb/undrop-for-innodb
The most reliable way would be import the table space in 5.6. Upgrade to 5.6 is not a bad idea anyway.
Upvotes: 1
Related Questions
- Restore table structure from frm and ibd files
- Restore the mysql database from .frm files
- MySQL InnoDB database restore using .frm files and ibdata files
- Restore MySQL InnoDb from *.frm files
- Recover MySQL InnoDB data/structure from .frm (no .myd and .myi, ibdada, my.ini) files
- How do I re-create a MySQL InnoDB table from an .ibd file?
- How do I recreate an FRM file for an MySQL InnoDB table with only the ibdata and *.ibd files?
- Recover DB from ibdata1, ib_logfile0, ib_logfile1 and .frm files
- How to get table structure from .frm files in mysql
- Recovering MySQl database from .frm, ibdata and ib_logfile