Richard Bensley added a comment - 2013-03-19 18:07 - edited initial requirements would probably include: [mysqld] innodb_file_per_table = ON innodb_file_format = Barracuda MySQL 5.6, extends the FLUSH command with the following syntax: FLUSH TABLES tbl_name [, tbl_name] ... FOR EXPORT As per: http://dev.mysql.com/doc/refman/5.6/en/flush.html MySQL 5.6 Transportable Tablespace : http://dev.mysql.com/doc/refman/5.6/en/tablespace-copying.html Exporting and Importing Tables (XtraDB) : http://www.percona.com/doc/percona-xtrabackup/xtrabackup_bin/exporting_importing_tables.html

VAROQUI Stephane added a comment - 2013-03-19 18:35 - edited Portable tablespace should be available to purge partitioned tables as this is mostly where it make sens to use it. Porting http://dev.mysql.com/doc/refman/5.6/en/partitioning-management-exchange.html would be nice

Jan Lindström (Inactive) added a comment - 2014-08-13 08:24 Tested with 10.0.x server and you can already export table from one server and import it to another.