Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- AWS_ACCESS_KEY_ID=***
- AWS_SECRET_ACCESS_KEY=***
- BUCKET=db-snapshots
- MYSQL_USER=***
- MYSQL_PASSWORD=***
- MYSQL_HOST=***
- MYSQL_DATABASE_NAME= 'database_name'
- TIMESTAMP=$(date +"%d-%b-%Y-%H-%M-%S")
- #logging
- LOG_ROOT="/backup/mysql_dump/logs/dump.log"
- #Dump of Mysql Database into S3
- echo "[db-take-snapshot]: creating backup of database $MYSQL_DATABASE_NAME start at $TSTAMP" >> "$LOG_ROOT"
- mysqldump -u $MYSQL_USER
- -p $MYSQL_PASSWORD
- -h $MYSQL_HOST
- --single-transaction
- --routines --triggers
- --database_name $MYSQL_DATABASES_NAME| gzip > backup.gz
- echo "[db-take-snapshot]:Finished backup of database and sending it in S3 Bucket at $TIMESTAMP" >> "$LOG_ROOT"
- S3_KEY=$BUCKET/backups/$(date "+%Y-%m-%d")-backup.gz
- aws s3 cp backup.gz s3://$S3_KEY --sse AES256
- echo "[db-take-snapshot]: Copied to S3 at $TIMESTAMP" >> "$LOG_ROOT"
- rm -f backup.gz
- echo "[db-take-snapshot]: Backup finished at $TIMESTAMP" >> "$LOG_ROOT"
- /db-take-snapshot-s3.sh: line 25: backup.gz: Permission denied
Add Comment
Please, Sign In to add comment