Closed jcalfee closed 3 years ago
Without coreutils:
/var/vmail/backup bash-5.0# ./backup_mysql.sh [...] ++ date '--date=90 days ago' +%Y date: invalid date '90 days ago' + shift_year= ++ date '--date=90 days ago' +%m date: invalid date '90 days ago' + shift_month= ++ date '--date=90 days ago' +%d date: invalid date '90 days ago' + shift_day= + export REMOVED_BACKUP_DIR=/var/vmail/backup/mysql/// + REMOVED_BACKUP_DIR=/var/vmail/backup/mysql/// + export REMOVED_BACKUP_MONTH_DIR=/var/vmail/backup/mysql// + REMOVED_BACKUP_MONTH_DIR=/var/vmail/backup/mysql// + export REMOVED_BACKUP_YEAR_DIR=/var/vmail/backup/mysql/ + REMOVED_BACKUP_YEAR_DIR=/var/vmail/backup/mysql/ + export LOGFILE=/var/vmail/backup/mysql/2020/12/19/2020-12-19-21-27-11.log + LOGFILE=/var/vmail/backup/mysql/2020/12/19/2020-12-19-21-27-11.log [...] ==> Backup completed successfully. + '[' XYES == XYES -a -d /var/vmail/backup/mysql/// ']' + echo -e '* Old backup found. Deleting: /var/vmail/backup/mysql///.' + rm -rf /var/vmail/backup/mysql/// + rmdir /var/vmail/backup/mysql// + rmdir /var/vmail/backup/mysql/ + sql_log_msg='INSERT INTO log (event, loglevel, msg, admin, ip, timestamp) VALUES ('\''backup'\'', '\''info'\'', '\''Remove old backup: /var/vmail/backup/mysql///.'\'', '\''cron_backup_sql'\'', '\''127.0.0.1'\'', UTC_TIMESTAMP());' + mysql --defaults-file=/root/.my.cnf -uroot iredadmin -e 'INSERT INTO log (event, loglevel, msg, admin, ip, timestamp) VALUES ('\''backup'\'', '\''info'\'', '\''Remove old backup: /var/vmail/backup/mysql///.'\'', '\''cron_backup_sql'\'', '\''127.0.0.1'\'', UTC_TIMESTAMP());' + echo '==> Detailed log (/var/vmail/backup/mysql/2020/12/19/2020-12-19-21-27-11.log):' ==> Detailed log (/var/vmail/backup/mysql/2020/12/19/2020-12-19-21-27-11.log): + echo ========================= ========================= + cat /var/vmail/backup/mysql/2020/12/19/2020-12-19-21-27-11.log cat: can't open '/var/vmail/backup/mysql/2020/12/19/2020-12-19-21-27-11.log': No such file or directory
Added:
# apk add coreutils fetch http://dl-cdn.alpinelinux.org/alpine/v3.12/main/x86_64/APKINDEX.tar.gz fetch http://dl-cdn.alpinelinux.org/alpine/v3.12/community/x86_64/APKINDEX.tar.gz (1/3) Installing libacl (2.2.53-r0) (2/3) Installing libattr (2.4.48-r0) (3/3) Installing coreutils (8.32-r0) Executing busybox-1.31.1-r19.trigger OK: 430 MiB in 267 packages bash-5.0# date --date='90 day ago' +%y%m%d 200920
With coreutils:
[...] + cat /var/vmail/backup/mysql/2020/12/19/2020-12-19-21-37-07.log * Starting backup: 2020-12-19-21-37-07. * Backup directory: /var/vmail/backup/mysql/2020/12/19. * Backing up databases: mysql vmail amavisd iredapd iredadmin roundcubemail sogo sa_bayes. * File size: ---- 12K amavisd-2020-12-19-21-37-07.sql.bz2 4.0K iredadmin-2020-12-19-21-37-07.sql.bz2 4.0K iredapd-2020-12-19-21-37-07.sql.bz2 276K mysql-2020-12-19-21-37-07.sql.bz2 8.0K roundcubemail-2020-12-19-21-37-07.sql.bz2 8.0K sa_bayes-2020-12-19-21-37-07.sql.bz2 4.0K vmail-2020-12-19-21-37-07.sql.bz2 ---- * Backup completed (Success? YES).
Thanks for the feedback. Fixed moment ago, nightly build should be available on Docker Hub in minutes. :)
Without coreutils:
Added:
With coreutils: