MariaDB Backup and Restore on Ubuntu 24.04

mariadb-dump (logical)

mariadb-dump -u root -p appdb > /backups/appdb_$(date +%F).sql
mariadb-dump -u root -p --all-databases --single-transaction > /backups/all_$(date +%F).sql

Restore

mariadb -u root -p appdb < /backups/appdb_2026-05-07.sql

Mariabackup (physical)

# Full backup
mariabackup --backup --target-dir=/backups/full_$(date +%F) --user=root --password=RootPass!
# Prepare
mariabackup --prepare --target-dir=/backups/full_2026-05-07
# Restore
systemctl stop mariadb
mariabackup --copy-back --target-dir=/backups/full_2026-05-07
chown -R mysql:mysql /var/lib/mysql
systemctl start mariadb

Binary log backup

[mysqld]
log_bin          = /var/log/mysql/mariadb-bin
expire_logs_days = 7

mariadb -u root -p -e "FLUSH BINARY LOGS;"