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

Can't extract :( #1

Open horkko opened 6 years ago

horkko commented 6 years ago

Hi,

Thanks for porting these scripts to debian ;) I've tried to give it a try. I'm currently working on debian 9. backup-mysql.sh is working correctly, no errors at all. However, when I try to use extract-mysql.sh I'm facing an error:

#  sudo -u backup extract-mysql.sh *.xbstream
extract-mysql.sh: An unexpected error occurred.  Try checking the "extract-progress.log" file for more information.

Looking at the error log file extract-progress.log this is the error I can see:

Extracting file full-11-13-2017_00-17-02.xbstream

mkdir: created directory './restore'
mkdir: created directory './restore/full-11-13-2017_00-17-02'
xtrabackup: Error: unknown argument: './restore/full-11-13-2017_00-17-02'

Finished work on full-11-13-2017_00-17-02.xbstream

And so on for other backup, either full or incremental.

Regarding backup-mysql.sh I use default options, I did not touch them.

I've tried to run the command line by hand as mariabackup --parallel=4 --decompress from either the restore directory or restore/full-.... directory but it alos failed with this error:

# mariabackup --parallel=4 --decompress
mariabackup based on MariaDB server 10.1.26-MariaDB debian-linux-gnu (x86_64)
mariabackup: Can't change dir to '/tmp/Mon/restore/xtrabackup_backupfiles/' (Errcode: 2 "No such file or directory")
cannot my_setwd /tmp/Mon/restore/xtrabackup_backupfiles/

For what I've seen, xtrabackup_backupfiles dir is missing. Maybe a missing option from backup-mysql.sh in order to create this extra directory?

Thanks for any clue. Regards Emmanuel

nullart commented 6 years ago

Hi @horkko

Thanks for this. I updated the extract script and added a missing parameter which I think will solve the bug in extract-mysql.sh.