How to recover InnoDB database from .frm and .ibd files

If you copy your database folder from xampp\mysql\data\
and paste to another xampp\mysql\data

then it will not work. From this tutorials you will learn how to restore innodb database from frm and ibd file.

Follow the tutorial carefully.

Please don't forget to subscribe my channel.

If you just copy your database folder and try to take this usable in another

[brentopc]

I got this error and it seems like a lot of people are getting the same

EXCEPTION: unpack requires a string argument of length 26
ERROR: Cannot read column header.

[ArifBillahOnGoogle]

Thank you man! Though the first part did not work in my case, so I had to create the tables manually, but the second part did indeed work fantastically. If you are wondering how I got the table column names, I just did a PHP file_get_contents on the frm file and it gave me the column names.

[balpreetsingh]

hey can you fix this error?

EXCEPTION: unpack requires a string argument of length 1
ERROR: Cannot read column data.

[bhaviksumera]

Im able to recover data but the Structure statement is not able to generate ❤

Thank you so much 🎉 for this method it is really helpfull to me 🎉

[anandmakwana]

it's work for .frm file only getting structure only not any data after try import tablespace command.

[SonuVerma-eniz]

Getting Exception in txt file >>> EXCEPTION: unpack requires a string argument of length 1
ERROR: Cannot read column data.

[romsong]

ALTER TABLE wp_comments IMPORT TABLESPACE;
ERROR 1815 (HY000): Internal error: Cannot reset LSNs in table `admin_peptech`.`wp_comments` : Data structure corruption I am getting this
how it will fixed

[hoseinshirdel]

I did the steps, but the error occurred to me: The system cannot find the path specified.

[Nick_U]

ALTER TABLE users IMPORT TABLESPACE;
ERROR 1808 (HY000): Schema mismatch (Expected FSP_SPACE_FLAGS=0x0, .ibd file contains 0x21.)


WARNING! Use -> ROW_FORMAT=DYNAMIC - it"s work. Thank you!

[NadunNilanga]

Thank you so mush this is really helpfull

[balaMurugan-fzge]

The txt file ia show 'Error cannot read column data '

[_varchasvigupta]

hello sir I am facing a same issue so i tried to apply your method but but commond prompt give me this " 'mysqlfrm' is not recognized as an internal or external command, operable program or batch file." how can i solve this now

[farazbit]

hi, thank you for this great tutorial, unfortunately, the end of the my txt file created is not the info of the table for create :(

[anandmakwana]

IT'S WORK BRO BUT DATA IS MISMATCH

[JahirulIslamMamun]

Thanks a lot.
I am getting all table back, but some tables data showing error
when I use --
ALTER TABLE wp_posts IMPORT TABLESPACE;
it's showing --
Schema mismatch (Clustered index validation failed. Because the .cfg file is missing, table definition of the IBD file could be different. Or the data file itself is already corrupted.)

[manikandankasi]

i have collation in use and my xampp is deleted by my collegue and if possible can i recover it with .frm file and IBD file

[entelekta]

All OK But this:
ALTER TABLE wpxo_yoast_seo_links IMPORT TABLESPACE;

#1815 - Internal error: Drop all secondary indexes before importing table aright/wpxo_yoast_seo_links when .cfg file is missing.

But good Video!

[Renge.]

i got "error 1030 (hy000): got error -1 from storage engine" when i use ALTER TABLE tbl_name DISCARD TABLESPACE; please help me!

[haisthorsepowa]

ERROR 2013 (HY000): Lost connection to MySQL server during query after doing ALTER TABLE <TABLE> IMPORT TABLESPACE

[davejanhavi]

I got this ERROR: Cannot read column data. plz give me solution