MySQL Forums
Forum List  »  InnoDB

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

Written By
Importing Data with Single .ibd file
September 06, 2014 04:12AM
September 07, 2014 12:06PM

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.