Re: Restoring raw innodb table files from replication server

[Aftab Khan]

In standard InnoDB, it is not normally possible to copy tables between servers by copying the files, even with innodb_file_per_table enabled. But XtraBackup allows to migrate individual table from any InnoDB database to Percona Server with XtraDB.

The table is required to be created with the option innodb_file_per_table enabled in the server, as exporting is only possible when table is stored in its own table space.

The importing server (at the moment it only supported by Percona Server) should have innodb_file_per_table and innodb_expand_import options enabled.

For more readings, see:

http://www.percona.com/doc/percona-xtrabackup/innobackupex/importing_exporting_tables_ibk.html