search

nullart / debian-ubuntu-mariadb-backup

This repository contains a few scripts for automating backups with mariabackup (a fork of Percona Xtrabackup)
46 stars 17 forks source link

prepare-mysql.sh seems to have wrong parameters for restore #3

Open digirave opened 7 years ago

digirave commented 7 years ago

Tested with: MariaDB-backup-10.2.11-1

mariabackup --apply-log "${full_backup_dir}" will definitely not run without --target-dir= in front of the "${full_backup_dir}"

Also according to https://www.percona.com/doc/percona-xtrabackup/LATEST/backup_scenarios/incremental_backup.html which mariabackup is officially based on shouldn't --apply-log "${full_backup_dir}" be --prepare --apply-log-only --target-dir="${full_backup_dir}"

Furthermore the shouldn't the incremental backups be applied with --prepare --apply-log-only --target-dir=[directory] --incremental-dir=[incrementaldirectory] followed with the last incremental backup as --prepare --apply-log-only --target-dir=[directory] --incremental-dir=[lastincrementaldirectory]

Thank you.

digirave commented 7 years ago

I seem to be correct regarding "--target-dir=" and probably "--prepare" but --apply-log-only seems to be removed in mariabackup https://jira.mariadb.org/browse/MDEV-13807