By default, all the files in the data directory are included in
the backup, so the backup includes data from all MySQL storage
engines, any third-party storage engines, and even any
non-database files in that directory. This section explains
options you can use to selectively back up or exclude data.
MySQL Enterprise Backup can make several kinds of partial backup:
Leaving out files that are present in the MySQL data
directory but not actually part of the MySQL instance. This
operation involves the
--only-known-file-types option.
Typically, a partial backup is more difficult to restore than
a full backup, because the backup data might not include the
necessary interrelated pieces to constitute a complete MySQL
instance. In particular, InnoDB tables have internal IDs and
other data values that can only be restored to the same
instance, not a different MySQL server. Always fully test the
recovery procedure for any partial backups to understand the
relevant procedures and restrictions.
© 2013, Oracle Corporation and/or its affiliates
User Comments
Add your own comment.