#!/bin/bash
AWS_ACCESS_KEY_ID=****** \
AWS_SECRET_ACCESS_KEY=****** \
AWS_DEFAULT_REGION=***** \
S3_BUCKET=[bucket name] \
MYSQL_HOST=127.0.0.1 \
MYSQL_PORT=8889 \
MYSQL_USER=root \
MYSQL_PASS=root \
MYSQL_DB=my_db \
cd /db_backup
file=$(date +%Y-%m-%d).sql
mysqldump \
  --host ${MYSQL_HOST} \
  --port ${MYSQL_PORT} \
  -u ${MYSQL_USER} \
  --password="${MYSQL_PASS}" \
  ${MYSQL_DB} > ${file}
gzip ${file}
/path/aws s3 cp ${file}.gz s3://${S3_BUCKET} --bucket S3_BUCKET
rm ${file}.gz