What is the alternative to move partitioning if this is not implemented?
Remove partitions in the source and then recreate them once it has been moved over?

marostegui,

You can import/export partitions without this feature using a workaround, but it can be a little tedious. I wrote a blog post about how to do so here:

http://www.geoffmontee.com/importing-innodb-partitions-in-mysql-5-6-and-mariadb-10-010-1/

Thanks for the link. I have tried it but I am getting lots of

Column type mismatch

The columns are obviously the same and forcing a rebuild doesn't help anyways.

On varchar columns, and I am importing between exactly the same server versions 10.1.19
So for the moment the only solution I have found is removing the partitions, doing the transfer and creating them again. Not ideal, but...

marostegui,

That's a pretty strange error to see if the columns really are exactly the same. Since these are varchar columns, do you know if the character encoding is the same on both servers?

If you want help tracking down the problem, feel free to post on the maria-discuss mailing list.

https://launchpad.net/~maria-discuss

A slightly different take on this the change in MySQL 5.7 also allows not just ALTER TABLE <table> DISCARD PARTITION <partitions> TABLESPACE for specific partitions. But seems to fix DISCARD TABLESPACE applied to the whole table as well which returns an error in Mariadb (10.2.6). Can we get that fix/improvement as well?

Maybe we should split this into two tickets, one for DISCARD/IMPORT support for partitioned tables in general, and one for being able to DISCARD/IMPORT specific partitions only?

I see that there is a feature

ALTER TABLE t1 EXCHANGE PARTITION p0 WITH TABLE t1p0;

I do not know if it is a viable work-around, but I would think using this syntax, you could export or import partitions as individual tables.

From the InnoDB point of view, each partition or subpartition that stores data is a normal table that uses a funny name.

MDEV-26137 made the step ALTER TABLE…DISCARD TABLESPACE optional.

In MDEV-13626, I came across the MySQL 5.7 tests innodb.innodb-import-partition-rpl and innodb.innodb-import-partition. The latter was originally added in the implementation of MySQL WL#6867.