Skip to content

Instantly share code, notes, and snippets.

@vivirenremoto

vivirenremoto/backup_all.sh

Last active April 14, 2020 18:02
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 vivirenremoto/1faa19d5eb494b605ad5f80988baab7e to your computer and use it in GitHub Desktop.
Save vivirenremoto/1faa19d5eb494b605ad5f80988baab7e to your computer and use it in GitHub Desktop.
Download ZIP
Backup files and databases to S3
Raw
backup_all.sh
DB_HOST="localhost"
DB_USER="xxx"
DB_PASS="xxx"
BUCKET="xxx"
DIR="/home/xxx"
#zip database
for DB in $(mysql --host=$DB_HOST --user=$DB_USER --password=$DB_PASS -e 'show databases' -s --skip-column-names); do mysqldump --host=$DB_HOST --user=$DB_USER --password=$DB_PASS $DB | gzip -9 > $DIR/../BACKUPS/DB/$DB.sql.gz; done;
#zip files
cd $DIR;
for i in */; do zip -r "$DIR/../BACKUPS/WEBS/${i%/}.zip" "$i"; done;
#upload s3
aws s3 mv $DIR/../BACKUPS s3://$BUCKET --recursive
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment