Skip to content

Instantly share code, notes, and snippets.

@MacoTasu

MacoTasu/mysqldump2s3

Last active March 31, 2016 06:44
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 MacoTasu/cf281d304b805c653cd02a2129a35128 to your computer and use it in GitHub Desktop.
Save MacoTasu/cf281d304b805c653cd02a2129a35128 to your computer and use it in GitHub Desktop.
Download ZIP
mysqlをdumpしてs3にアップロードするshell
Raw
mysqldump2s3
#!/bin/sh
mysqldump -h $MYSQL_HOST -u$MYSQL_USER_NAME -p$MYSQL_PASSWORD --single-transaction --master-data=2 $DB_NAME | gzip > mysqldump.sql.gz
date_str=`date +"%Y%m%d%I%M"`
aws s3 mv mysqldump.sql.gz s3://****-mysqldump/"${date_str}".sql.gz
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment