Skip to content

Instantly share code, notes, and snippets.

@shofetim

shofetim/bobosales-backup.sh

Created March 15, 2017 04:56
Show Gist options
  • Save shofetim/e52ba8a90a46a08c69f9156d44c7171c to your computer and use it in GitHub Desktop.
Save shofetim/e52ba8a90a46a08c69f9156d44c7171c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
bobosales-backup.sh
export PGPASSWORD=redacted
export AWS_ACCESS_KEY_ID=redacted
export AWS_DEFAULT_REGION=us-west-2
export AWS_SECRET_ACCESS_KEY=redacted
pg_dump -h shops-ksl-com.cxpx7kkpqtcv.us-west-2.rds.amazonaws.com -U redacted redacted | gzip | mpipe ~~/stor/bobosales/`date +%Y-%m-%d`-backup.sql.gz
easy_install-2.7 awscli
aws s3 sync s3://images.bobosales.com/ images/
tar -cf images.tar images
gzip images.tar
mput -f images.tar.gz ~~/stor/bobosales/images.tar.gz
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment