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.
See also backup.
See also mysqldump.
See also physical backup.
See also restore.