I have one ".ibd" file with me. I have configured my local Database server with FILE_PER_TABLE option. i have two question here.

  1. When i was trying to restore/import the IBD file, the engine expect me to have the structure information. Is it not possible to load the data and structure using Single IBD file?

  2. Also can we do hot copy and restore the innodb files from one server to other as MyISAM engine?

Please need your suggestion on the same.

  • You can't copy the ibd files to another MySQL instance without some hackery because the metadata in the ibd file won't match what's in the global InnoDB data dictionary. Instead you can use one of the methods that Vérace describes. – James L Sep 6 '14 at 11:40

1) To get a single table restored and/or imported, use mysqldump. See the "how" links in my post here.

2) For a hot copy of InnoDB tables, use Perconas XtraBackup tool (BTW, the Percona website generally and their mysqlperformance blog are excellent MySQL resources).

You can also replicate from InnoDB masters to MyISAM slaves and the other way round (although why one would want to do this is a mystery to me).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.