Skip to content

Instantly share code, notes, and snippets.

@Ruzzz

Ruzzz/backup_mysql_to_dropbox.sh

Created June 22, 2018 13:15
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 Ruzzz/438eda071577c05a18203fc3d3eeb948 to your computer and use it in GitHub Desktop.
Save Ruzzz/438eda071577c05a18203fc3d3eeb948 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
backup_mysql_to_dropbox.sh
# DEPS:
# https://github.com/dropbox/dbxcli
# sudo apt-get install p7zip-full
DB_USER=
DB_PASS=
DB_NAME=
DB_TABLES=
ARC_PASS=
mysqldump -u$DB_USER -p$DB_PASS $DB_NAME $DB_TABLES > $DB_NAME.sql
7za a -y -t7z -mx9 -mhe=on -mtc=on -m0=LZMA2 -p$ARC_PASS $DB_NAME.7z $DB_NAME.sql
dbxcli put $DB_NAME.7z /backups/$DB_NAME.7z
rm $DB_NAME.sql $DB_NAME.7z
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment