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/2032/ 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....@lists.launchpad.net] On Behalf Of Colin Charles Sent: Tuesday, January 05, 2016 9:42 AM To: MariaDB discuss <[email protected]>; Ian Gilfillan <[email protected]>; Jan Lindström <[email protected]> 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-examples.html 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 _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
