Hot MySQL Backup with Percona XtraBackup

MySQL / MariaDB · 19.04.2026

Hot MySQL Backup with Percona XtraBackup

Unlike mysqldump, Percona XtraBackup creates InnoDB backups without table locks or server downtime. Essential for databases over 10GB.

Install XtraBackup

wget https://repo.percona.com/apt/percona-release_latest.generic_all.deb
dpkg -i percona-release_latest.generic_all.deb
percona-release setup pdps-80
apt update && apt install percona-xtrabackup-80

Full Backup

xtrabackup --backup \
  --user=root \
  --password='YourPass' \
  --target-dir=/backup/full

xtrabackup --prepare --target-dir=/backup/full

Incremental Backup

xtrabackup --backup \
  --user=root \
  --password='YourPass' \
  --target-dir=/backup/inc1 \
  --incremental-basedir=/backup/full

Tip: Add --compress and --encrypt=AES256 flags to save space and secure backups.