Skip to content

Instantly share code, notes, and snippets.

@rushi216
Created March 30, 2017 04:25
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 rushi216/c22c4422aef32d9466e40631b2a79b52 to your computer and use it in GitHub Desktop.
Save rushi216/c22c4422aef32d9466e40631b2a79b52 to your computer and use it in GitHub Desktop.
#!/bin/sh
HOST=XXX
DATABASE=XXX
USER=XXX
PASS=XXX
FILE=db-`date +"%d"`.sql
mysqldump --opt --host=${HOST} --user=${USER} --password=${PASS} ${DATABASE} > ${FILE}
tar -zcvf $FILE.tar.gz $FILE
rm $FILE
echo "${FILE}.tar.gz was created:"
AWS_ACCESS_KEY_ID=XXX
AWS_SECRET_ACCESS_KEY=XXX
AWS_DEFAULT_REGION=XXX
S3_BUCKET=XXX
aws s3 cp ${FILE}.tar.gz s3://${S3_BUCKET}
rm ${FILE}.tar.gz
echo "${FILE}.tar.gz was uploaded to s3 on bucket ${S3_BUCKET}"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment