#!/bin/bash
set -euo pipefail
APP=/var/www/html/download-data-laravel
DEST=/var/backups/editorvn
DBU=$(sed -n 's/^DB_USERNAME=//p' "$APP/.env" | head -n1)
DBP=$(sed -n 's/^DB_PASSWORD=//p' "$APP/.env" | head -n1)
DBN=$(sed -n 's/^DB_DATABASE=//p' "$APP/.env" | head -n1)
STAMP=$(date +%Y%m%d-%H%M%S)
umask 077
mysqldump --single-transaction --routines --triggers --protocol=TCP -h127.0.0.1 -P3307 -u"$DBU" -p"$DBP" "$DBN" 2>/dev/null | gzip -9 > "$DEST/$DBN-$STAMP.sql.gz"
find "$DEST" -type f -name '*.sql.gz' -mtime +14 -delete
