Skip to content

Instantly share code, notes, and snippets.

@tatey
Created August 14, 2010 08:46
Show Gist options
  • Save tatey/524145 to your computer and use it in GitHub Desktop.
Save tatey/524145 to your computer and use it in GitHub Desktop.
#!/bin/bash
FILENAME="dbname.$(date +'%Y%m%d%H%M').sql"
BUCKET="bucketname"
mysqldump -u dbuser --password=secret dbname > "$FILENAME"
gzip "$FILENAME"
s3cmd put "$BUCKET:$FILENAME.gz" "$FILENAME.gz" "Content-Type:application/x-gzip"
rm "$FILENAME.gz"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment