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 /dumps | |
| parent | 958f4509286b2e45c805d6dc583be3b5e570db25 (diff) | |
S3 backup script for butler DBs
Diffstat (limited to 'dumps')
| -rw-r--r-- | dumps/.backup | 3 | ||||
| -rwxr-xr-x | dumps/backup-dbs.sh | 6 | ||||
| -rw-r--r-- | dumps/backup/.gitignore | 1 |
3 files changed, 10 insertions, 0 deletions
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 |