Priyank Patel ppatelcodal
ppatelcodal
/ mysql_backup_db_script.sh
Last active
May 25, 2017 12:06
BASH Script to backup RDS/EC2 MySQL DB and upload to S3 weekly
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # Run as sudo. for weekly backup of db. and upload to s3 bucket. | |
| DBHOME="/home/ubuntu/priyank/crontabs/dbbackups/" | |
| BUCKETNAME="yourAWSbucket" | |
| SCRIPTNAME="$(basename $BASH_SOURCE)" | |
| SCRIPTFULLPATH="$(pwd)/$(basename $BASH_SOURCE)" | |
| mkdir -p $DBHOME | |
| chown -R ubuntu:ubuntu $DBHOME | |
| cp $SCRIPTFULLPATH $DBHOME | |
| SCHEMA_BACKUP="$DBHOME/$(date +%w).gzip" |
ppatelcodal
/ pg_backup_db_script.sh
Last active
October 25, 2017 15:43
BASH Script to backup RDS/EC2 PostgreSQL DB and upload to S3 weekly
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # Run as sudo. for weekly backup of db. and upload to s3 bucket. | |
| DBHOME="/home/priyank/crontabs/dbbackups/" | |
| BUCKETNAME="yourAWSbucket" | |
| SCRIPTNAME="$(basename $BASH_SOURCE)" | |
| SCRIPTFULLPATH="$(pwd)/$(basename $BASH_SOURCE)" | |
| mkdir -p $DBHOME | |
| chown -R postgres:postgres $DBHOME | |
| cp $SCRIPTFULLPATH $DBHOME | |
| SCHEMA_BACKUP="$DBHOME/$(date +%w).sql" |