MariaDB

Database Maintenance and Monitoring script

Backup & Restore

refer to https://mariadb.com/docs/recovery/backup-optimization/

• Take a full backup:

sudo mariabackup --backup \
      --user=root \
      --password=P@ssw0rdINDO7Kali \
      --target-dir=/home/backup/db

Confirm successful completion of the backup operation.

• The backup must be prepared:

sudo mariabackup --prepare \
      --target-dir=/home/backup/db

Confirm successful completion of the prepare operation.