Skip to content

Instantly share code, notes, and snippets.

@devzorg

devzorg/Backing up FS and gzipped DB

Last active March 14, 2018 07:47
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 devzorg/1ecbdecf7e1ae22ff295b0a631042c53 to your computer and use it in GitHub Desktop.
Save devzorg/1ecbdecf7e1ae22ff295b0a631042c53 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Backing up FS and gzipped DB
#!/bin/bash
USER=user
PASS=pass
DBNAME=dbname
BKP_PATH=/backups
PATH=/var/www/site/data/www
mysqldump -u${USER} -p --lock-tables=false --single-transaction --quick --hex-blob --routines --triggers ${DBNAME} | gzip > ${DBNAME}_(DATE).sql.gz &
tar -C ${PATH} -zcpf ${BKP_PATH}/${DBNAME}.tgz ./
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment