Skip to content

Instantly share code, notes, and snippets.

@roydejong

roydejong/mysql-backup-to-s3

Last active August 13, 2021 07:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save roydejong/ef9228e608d9f4fe342af93395bff1a4 to your computer and use it in GitHub Desktop.
Save roydejong/ef9228e608d9f4fe342af93395bff1a4 to your computer and use it in GitHub Desktop.
Download ZIP
Cron script: MySQL Nightly Backups to S3
Raw
mysql-backup-to-s3
#!/bin/bash
# /etc/cron.daily/mysql-s3-backup
# Before use, install AWS CLI and use "aws configure" to set up credentials with write access to your s3 bucket
# See https://docs.aws.amazon.com/cli/latest/userguide/install-cliv2-linux.html#cliv2-linux-install
DB_USER=XXX
DB_NAME=XXX
DB_PASS=XXX
BUCKET_NAME=XXX
BACKUP_FILENAME=$DB_NAME-$(date +%Y-%m-%dT%H:%M:%S).sql.gz
mysqldump $DB_NAME -u $DB_USER -p$DB_PASS | gzip > $BACKUP_FILENAME
aws s3 cp $BACKUP_FILENAME s3://$BUCKET_NAME
rm $BACKUP_FILENAME
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment