Skip to content

Instantly share code, notes, and snippets.

@khatchad
Created January 14, 2021 17:29
MySQL backup script
#!/bin/bash
USER=""
PASSWORD=""
OUTPUT="$HOME/backup"
DATABASES=("skeletal_implementers" "phpmyadmin" "skeletal_implementers_abstract_only")
MYSQL_DUMP="/opt/bitnami/mysql/bin/mysqldump"
REMOTE_DIR="ftp://websupport1.citytech.cuny.edu/backup/"
REMOTE_USER=""
REMOTE_PWD=""
for db in ${DATABASES[*]}; do
FILE=$OUTPUT/`date +%Y%m%d`.$db.sql
echo "Dumping database: $db to: $FILE"
$MYSQL_DUMP --force --opt --user=$USER --password=$PASSWORD --databases $db > $FILE
gzip --force $FILE
curl -T $FILE.gz $REMOTE_DIR --user $REMOTE_USER:$REMOTE_PWD
done
cd "$OUTPUT"
find *.gz -mtime +21 -delete > /dev/null 2>&1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment