How do I re-create a MySQL InnoDB table from an .ibd file?

knorv picture knorv · Apr 8, 2010 · Viewed 47.4k times · Source

Assume that the following MySQL files have been restored from a backup tape:

  • tablename.frm
  • tablename.ibd

Furthermore, assume that the MySQL installation was running with innodb_file_per_table and that the database was cleanly shutdown with mysqladmin shutdown.

Given a fresh install of the same MySQL version that the restored MySQL files were taken from, how do I import the data from tablename.ibd/tablename.frm into this new install?

Answer

Snehasish Sarkar picture Snehasish Sarkar · Nov 28, 2016

Similar thing is answered here. please have a look https://stackoverflow.com/a/10943833/3985205

Yes this is possible. It is not enough you just copy the .frm files to the to the databse folder but you also need to copy the ib_logfiles and ibdata file into your data folder. I have just copy the .frm files and copy those files and just restart the server and my database is restored.