Question
Logical dump versus physical backup: how do recovery trade-offs differ?
Answer
A logical dump contains SQL definitions and rows; a physical backup copies database files. Use logical dumps for selective, portable restores; use physical backups when faster backup and restore outweigh portability. Applies to MySQL and MariaDB.