Skip to content

Instantly share code, notes, and snippets.

@refo
Created February 2, 2021 12:55
#!/usr/bin/env bash
DBNAME=$1
DIR=$2
DUMP=/usr/bin/mysqldump
PREFIX="${DBNAME}";
SUFFIX=$(date +"%F-%H%M%S");
FILENAME="${PREFIX}-${SUFFIX}.sql";
FILEPATH="${DIR}/${FILENAME}"
echo "Backing up ${FILEPATH}"
$DUMP "${DBNAME}" --result-file="${FILEPATH}"
# crontab -e
# /root/scripts/db-backup "db_name" /root/backup 2>&1 >> /root/backup/backup.log
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment