Physical (Raw) Versus Logical Backups

Physical (Raw) Versus Logical Backups

  Physical backups consist of raw copies of the directories and files that store database contents. This type of backup is suitable for large, important databases that need to be recovered quickly when problems occur.

  Logical backups save information represented as logical database structure (CREATE DATABASECREATE TABLE statements) and content (INSERT statements or delimited-text files). This type of backup is suitable for smaller amounts of data where you might edit the data values or table structure, or recreate the data on a different machine architecture.

  

参考:https://dev.mysql.com/doc/refman/5.7/en/backup-types.html

原文地址:https://www.cnblogs.com/tekkaman/p/7421105.html