Skip to content

Instantly share code, notes, and snippets.

/mysqlbackup.sh Secret

Created May 1, 2017 19:00
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 anonymous/7061449508acaf18c8eb2461b1d62074 to your computer and use it in GitHub Desktop.
Save anonymous/7061449508acaf18c8eb2461b1d62074 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysqlbackup.sh
#!/bin/sh
BACKUP_FILENAME="MYSITE_sql_$(date +%F_%H%M%S).gz"
OBJECT_NAME="$(date +%Y)/$(date +%m)/$BACKUP_FILENAME"
mysqldump -u root -pPASSWORD database_name | gzip -9 > /var/backups/$BACKUP_FILENAME
/usr/local/bin/swift upload --object-name $OBJECT_NAME backups-mysite /var/backups/$BACKUP_FILENAME
shred -u /var/backups/$BACKUP_FILENAME
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment