tablespace-copying

This page has moved or been replaced. The new page is located here:

https://dev.mysql.com/doc/refman/5.6/en/innodb-table-import.html

Please update any bookmarks that point to the old page.


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
  Posted by Patrice Levesque on December 6, 2018
IMPORT TABLESPACE is *not* master-slave replication-friendly.

The slave replication thread will choke on errors similar to:

Worker X failed executing transaction '' at master log mysql-bin.000008, end_log_pos 848099; Error 'Table 'foo.bar' doesn't exist' on query. Default database: 'foo'. Query: 'ALTER TABLE `bar` IMPORT TABLESPACE'

See the corresponding bug on MariaDB: https://jira.mariadb.org/browse/MDEV-12437