Answer
Logical backups export SQL statements, while physical backups copy actual data files. Physical backups are faster for large datasets.
Quick Answer
Logical backup: exports data as SQL statements (INSERT) or CSV - readable, portable, slow to restore. Tools: mysqldump, mysqlpump. Physical backup: copies raw data files - fast to restore, same MySQL version required. Tools: MySQL Enterprise Backup, Percona XtraBackup (hot backup - no downtime). Use logical for small databases and portability, physical for large databases where restore speed matters.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ