I have one ".ibd" file with me. I have configured my local Database server with FILE_PER_TABLE option. i have two question here.
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?
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.