diff options
| author | emkael <emkael@tlen.pl> | 2022-10-23 13:29:58 +0200 |
|---|---|---|
| committer | emkael <emkael@tlen.pl> | 2022-10-23 13:29:58 +0200 |
| commit | f7ed9ac02bc55e1d76b9c59b316e645aaf7284de (patch) | |
| tree | 1186315bf414422d6f80d5effa727e2d8b1df08f | |
| parent | 958f4509286b2e45c805d6dc583be3b5e570db25 (diff) | |
S3 backup script for butler DBs
| -rw-r--r-- | .envrc | bin | 916 -> 979 bytes | |||
| -rw-r--r-- | Makefile | 6 | ||||
| -rw-r--r-- | dumps/.backup | 3 | ||||
| -rwxr-xr-x | dumps/backup-dbs.sh | 6 | ||||
| -rw-r--r-- | dumps/backup/.gitignore | 1 |
5 files changed, 15 insertions, 1 deletions
| Binary files differ @@ -21,8 +21,12 @@ lineups: FORCE checks: paid teams lineups +backups: FORCE + ./dumps/backup-dbs.sh + s3cmd -c dumps/.s3config --exclude="*/*" sync dumps/backup/ ${LIGA_S3_BACKUP_BUCKET} + dumps: FORCE - s3cmd -c dumps/.s3config sync ${LIGA_S3_BUCKET} dumps/sync/ + s3cmd -c dumps/.s3config --exclude="*/*" sync ${LIGA_S3_BUCKET} dumps/sync/ ./dumps/load-dumps.sh butler: FORCE diff --git a/dumps/.backup b/dumps/.backup new file mode 100644 index 0000000..268874a --- /dev/null +++ b/dumps/.backup @@ -0,0 +1,3 @@ +dmp202223_b0 +dmp202223_b1 +dmp202223_b2 diff --git a/dumps/backup-dbs.sh b/dumps/backup-dbs.sh new file mode 100755 index 0000000..29e6367 --- /dev/null +++ b/dumps/backup-dbs.sh @@ -0,0 +1,6 @@ +#!/bin/bash +cd $(dirname $0) +grep -v '^#' .backup | while read DB +do + mysqldump --column-statistics=0 ${LIGA_MYSQL_CONNECTION_OPTS} $DB > backup/$DB.sql +done diff --git a/dumps/backup/.gitignore b/dumps/backup/.gitignore new file mode 100644 index 0000000..d1b811b --- /dev/null +++ b/dumps/backup/.gitignore @@ -0,0 +1 @@ +*.sql |