MariaDB Backup & Restore

# Full logical backup mysqldump -u root -p \ --single-transaction \ --master-data=2 \ --routines --triggers --events \ --all-databases | gzip > full_$(date +%Y%m%d).sql.gz # Physical full backup mariabackup --backup \ --target-dir=/backup/full_$(date +%Y%m%d) \ --user=root --password=secret # Incremental backup mariabackup --backup \ --target-dir=/backup/incr_$(date +%Y%m%d_%H%M) \ --incremental-basedir=/backup/full_20240101 \ --user=root --password=secret # Point-in-Time Recovery # 1. Restore base backup mariabackup --prepare --target-dir=/backup/full_20240101 mariabackup --copy-back --target-dir=/backup/full_20240101 # 2. Apply binary logs to specific time mysqlbinlog --stop-datetime="2024-01-15 14:30:00" \ /var/lib/mysql/mysql-bin.* | mysql -u root -p