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 detailed procedure.
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]