MySQL Enterprise Backup User's Guide (Version 4.1.4)

16.8 Partial Backup and Restore Options


Since MySQL Enterprise Backup 3.10, the two options --include-tables and --exclude-tables have been introduced. These were intended for replacing the older options of --include, --databases, --databases-list-file, and --only-innodb-with-frm, which are incompatible with the new options and will be deprecated in future releases. For references purpose, we have included information on the older options at the end of this section in Legacy Partial Backup Options.

To select specific data to be backed up or restored, use the partial backup and restore options described in this section.

For an overview of partial backup and usage examples on the following options, see Section 4.3.5, “Making a Partial Backup”. See also Section 5.1.4, “Restoring Backups Created with the --use-tts Option”, on selective restore of tables from a backup.

Legacy Partial Backup Options


Information in this subsection is only for using the legacy options of --include, --databases, --databases-list-file, and --only-innodb-with-frm, which will be deprecated in the upcoming issues. For creating partial backups, it is strongly recommended that the new options of --include-tables and --exclude-tables be used instead. Note that you cannot combine the legacy and the new partial-backup options in a single command.

Besides the legacy options, some other options are also discussed below, but the information is only for using the options together with the legacy partial-backup options.

For an overview of partial backups and usage examples for these legacy options, see Making a Partial Backup with the Legacy Options.