Skip to main content

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.

More lessons in Backup & Restore