Importing InnoDB Partitions in MariaDB 10.0/10.1

Transportable tablespaces for InnoDB tables is a very useful feature added in MySQL 5.6 and MariaDB 10.0. With this new feature, an InnoDB table’s tablespace file can be copied from one server to another, as long as the table uses a file-per-table tablespace.

Unfortunately, the initial transportable tablespace feature in MySQL 5.6 and MariaDB 10.0 does not support partitioned tables. Support for partitioned tables was added in MySQL 5.7. This feature will also likely be added to MariaDB 10.2 since it will contain MySQL 5.7’s InnoDB implementation. However, having this feature in new versions doesn’t help you much if you wanted to use this feature in the older versions of MySQL or MariaDB.

The good news is that there is a workaround that allows you to use transportable tablespaces in MySQL 5.6 and MariaDB 10.0/10.1 to copy partitioned tables from one server to another. For a step-by-step guide on how to use the workaround, check out my blog post here.