MySQL逻辑备份和物理备份

MySQL逻辑备份和物理备份

1. 逻辑备份

logical backup
A backup that reproduces table structure and data, without copying the actual data files. For example, the
mysqldump command produces a logical backup, because its output contains statements such as CREATE
TABLE and INSERT that can re-create the data. Contrast with physical backup. A logical backup offers flexibility
(for example, you could edit table definitions or insert statements before restoring), but can take substantially
longer to restore than a physical backup.

2. 物理备份

physical backup
A backup that copies the actual data files. For example, the mysqlbackup command of the MySQL Enterprise
Backup product produces a physical backup, because its output contains data files that can be used directly by
the mysqld server, resulting in a faster restore operation. Contrast with logical backup.
See Also backup, logical backup, MySQL Enterprise Backup, restore.