MySQL Forums :: InnoDB :: Importing Data with Single .ibd file


Advanced Search

Importing Data with Single .ibd file
Posted by: deepak m ()
Date: September 06, 2014 04:12AM

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.

Options: ReplyQuote


Subject Views Written By Posted
Importing Data with Single .ibd file 1368 deepak m 09/06/2014 04:12AM
Re: Importing Data with Single .ibd file 583 Rick James 09/07/2014 12:06PM
Re: Importing Data with Single .ibd file 589 Marko Mäkelä 09/10/2014 07:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.