Mysqldump is a fantastic tool for backing up
and restoring small and medium sized MySQL tables and databases
quickly. However, when databases surge into the
multi-terabyte range restoring from logical backups is
inefficient. It can take a significant amount of time to insert a
hundred million plus rows to a single table, even with very fast
I/O. Programs like MySQL Enterprise Backup and Percona XtraBackup
allow non-blocking binary copies of your InnoDB tables to be
taken while it is online and processing requests. XtraBackup also
has an export feature that allows InnoDB file per tablespaces to
be detached from the shared table space and imported to a
completely different MySQL instance.
The necessary steps to export and import InnoDB tables are in the
XtraBackup documentation …
Feb
10
2014