Copying huge InnoDB table as IBD file?
We have a huge InnoDB table (153G) that we need to move to another server. We use innodb_file_per_table. Is there a way to copy just the IBD file somehow? How would target DB recognize the file and know about its metadata? If needed, we can stop the DB for the copying.
P.S. this is done for importing data from a number of huge CSVs (1B, 250M, 140M lines). We are thinking of simultaneously importing different CSVs on 2 computers, and then copying populated IBD file to one of the machines. This would allow us to minimize migration/import window.
Subject
Views
Written By
Posted
Copying huge InnoDB table as IBD file?
5050
June 01, 2011 01:30PM
1992
July 17, 2011 02:17PM
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.