Logical vs Physical Backup
Learn Logical vs Physical Backup (Backup & Restore, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction A logical backup exports the data as SQL statements (or delimited text) that can be replayed. A physical backup copies the raw data files (tablespaces, redo, binlog position). Logical is portable and readable; physical is much faster for large data sets.