I've used the FLUSH TABLES ... FOR EXPORT feature plenty of times. I think from version 10.0.10 - 10.0.14. It works fine. Here's the process I Used... http://www.youdidwhatwithtsql.com/moving-innodb-database-flush-tables-export... I didn’t find any explicit reference to the CREATE TABLESPACE command either but it does seem to function... CREATE TABLESPACE rhys ADD DATAFILE 'rhys.ibd' ENGINE = InnoDB; (MariaDB 10.0.20) Cheers, Rhys -----Original Message----- From: Maria-discuss [mailto:maria-discuss-bounces+rhys.campbell=swisscom.com@lists.launchpad.net] On Behalf Of Colin Charles Sent: Tuesday, January 05, 2016 9:42 AM To: MariaDB discuss <maria-discuss@lists.launchpad.net>; Ian Gilfillan <ian@mariadb.org>; Jan Lindström <jan.lindstrom@mariadb.com> Subject: [Maria-discuss] Transportable (portable) tablespaces Hi, I haven’t tested this yet (the joys of vacation that still keeps you coming back to the lists), but thought I’d approach this as a user searching the Knowledgebase :-) This is a feature from 5.6, and it has improved in 5.7. I saw https://mariadb.atlassian.net/browse/MDEV-4299 saying that it works (looks like Serg did the merge — http://bazaar.launchpad.net/~maria-captains/maria/10.0/revision/3965.1.18 for 10.0.8), but I couldn’t find any documentation suggesting that such a feature exists, eg. https://dev.mysql.com/doc/refman/5.7/en/innodb-transportable-tablespace-exam... One of the “improvements” that I guess we’ll be getting is, the ability to use the CREATE TABLESPACE command — https://dev.mysql.com/doc/refman/5.7/en/create-tablespace.html (vs. https://mariadb.com/kb/en/mariadb/create-tablespace/) Looking forward to more information/discussion, and also if this is a docs bug, I guess I CC’ed Ian cheers, -colin -- Colin Charles, http://bytebot.net/blog/ twitter: @bytebot | skype: colincharles "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi