MySQL Forums
Forum List  »  Other Migration

Copying huge InnoDB table as IBD file?
Posted by: Leonid Finis
Date: June 01, 2011 01:30PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Copying huge InnoDB table as IBD file?
5050
June 01, 2011 01:30PM


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.