forked from infra/ansible
Kevin Fenzi
84f0b9db1e
This db is no longer used/copied/needed. Signed-off-by: Kevin Fenzi <kevin@scrye.com>
39 lines
1.6 KiB
Bash
Executable file
39 lines
1.6 KiB
Bash
Executable file
#!/bin/bash
|
|
|
|
#
|
|
# A simple script to copy database dumps over to public space on batcave01
|
|
# Only the most recent dump is published
|
|
#
|
|
|
|
# We need to set -e so that `chronic` will make the right decision about alerting
|
|
# us to any failures.
|
|
set -e
|
|
|
|
# This changes really often ;)
|
|
bkup_domain=rdu3.fedoraproject.org
|
|
|
|
scp db-datanommer02.${bkup_domain}:/backups/datanommer2-$(date +%F).dump.xz \
|
|
/srv/web/infra/db-dumps/datanommer2.dump.xz
|
|
# Always yesterday because the export needs to ensure a full day's worth of data
|
|
scp db-datanommer02.${bkup_domain}:/backups/datanommer-incremental/$(date -d 'yesterday' +%F)-datanommer-incremental-csv.tar \
|
|
/srv/web/infra/db-dumps/datanommer-incremental/
|
|
|
|
scp db-koji01.${bkup_domain}:/backups/koji-$(date +%F).dump.xz \
|
|
/srv/web/infra/db-dumps/koji.dump.xz
|
|
|
|
scp db01.${bkup_domain}:/backups/koschei-$(date +%F).dump.xz \
|
|
/srv/web/infra/db-dumps/koschei.dump.xz
|
|
scp db01.${bkup_domain}:/backups/bodhi2-$(date +%F).dump.xz \
|
|
/srv/web/infra/db-dumps/bodhi2.dump.xz
|
|
scp db01.${bkup_domain}:/backups/anitya-public-$(date +%F).dump.xz \
|
|
/srv/web/infra/db-dumps/anitya.dump.xz
|
|
scp db01.${bkup_domain}:/backups/mailman-$(date +%F).dump.xz \
|
|
/srv/web/infra/db-dumps/mailman.dump.xz
|
|
scp db01.${bkup_domain}:/backups/hyperkitty-$(date +%F).dump.xz \
|
|
/srv/web/infra/db-dumps/hyperkitty.dump.xz
|
|
scp db01.${bkup_domain}:/backups/resultsdb-$(date +%F).dump.xz \
|
|
/srv/web/infra/db-dumps/resultsdb.dump.xz
|
|
scp db01.${bkup_domain}:/backups/waiverdb-$(date +%F).dump.xz \
|
|
/srv/web/infra/db-dumps/waiverdb.dump.xz
|
|
scp db01.${bkup_domain}:/backups/tahrir-$(date +%F).dump.xz \
|
|
/srv/web/infra/db-dumps/tahrir.dump.xz
|