Database administration: MariaDB, MySQL and PostgreSQL in production
Exit

Lesson 5 of 12 · Back up and restore

Physical backups and point-in-time restore: mariadb-backup, pg_basebackup, binlogs and WAL

1 h 10 min Debian 13 Versions MariaDB 10.11 à 11.8, MySQL 8.4, PostgreSQL 15 à 18

Objective

Know how to bring back a whole server quickly (physical copy) and return to any moment between two backups, for example the second before an unfortunate DROP TABLE.

This lesson is part of the full course

Unlock Database administration: MariaDB, MySQL and PostgreSQL in production to read every lesson, do the exercises, access the simulations and earn your certificate.

Already enrolled? Log in.