So quite fast way to move tables. But what about moving one table from one server to another server? Here is a show of transportable tablespaces begin. If you want to use this features you must have a MySQL 5.6.x a good one the latest GA. and it must be started as innodb_file_per_table = 1. Ofcourse you must have identical database names and table names on both side. We have already test_table2 table in test database on linuxsrv3. Created on linuxsrv4 same database and table. Our source server is: linuxsrv3 Destination server is: linuxsrv4 On destination server discard existing tablespace: