In this post I will explain how to transfer a partitioned table
using transportable tablespaces on MySQL 5.6. Note that the
operation is not officially supported until MySQL 5.7, as the
discard tablespace operation will fail if it is run against a
partitioned table on MySQL 5.6.
The workaround is transferring each individual partition as if it
was a standalone table. Continue reading to learn more about the
1. Create the same table structure on the destination server:
[root@mysqlsandbox ~]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.35-80.0 Percona Server (GPL), Release 80.0, Revision f113994f31
Copyright (c) 2009-2016 Percona LLC and/or its affiliates
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. …[Read more]