MySQL 5.6 introduced the TTS(transportable table spaces) feature which
enables moving a table from one server to another. This feature
coupled with MEB 3.9 enables backing up a set of tables matching
(regex specified with) the –include option.
The backup of selective tables using transportable tablespaces
feature of innodb is referred as tts/selective backup in the
remainder of the section.
The difference between a regular partial backup and with using
tts is that the regular partial backups are stand alone and
cannot be plugged into a another server where as the tts backups
in contrast enables the tables to be plugged into another server
instance
The …
[Read more]