MySQL / MariaDB DBA

Backup, PITR & Restore

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.

This is 4 of 23 free samples for MySQL / MariaDB DBA.

More MySQL / MariaDB DBA topic samples