how to fast copy a large innodb table

how to fast copy mysql innodb table size开发者_JAVA百科 8.4G?

---

the fast way is to copy the files but to do this in innodb engine you need to use

Per-Table Tablespaces

Using multiple tablespaces can be beneficial to users who want to move specific tables to separate physical disks or who wish to restore backups of single tables quickly without interrupting the use of other InnoDB tables.