summaryrefslogtreecommitdiff
path: root/tools/clickhouse-backup.sh
diff options
context:
space:
mode:
authorEvgeny Zinoviev <me@ch1p.io>2023-09-27 00:54:57 +0300
committerEvgeny Zinoviev <me@ch1p.io>2023-09-27 00:54:57 +0300
commitd3a295872c49defb55fc8e4e43e55550991e0927 (patch)
treeb9dca15454f9027d5a9dad0d4443a20de04dbc5d /tools/clickhouse-backup.sh
parentb7cbc2571c1870b4582ead45277d0aa7f961bec8 (diff)
parentbdbb296697f55f4c3a07af43c9aaf7a9ea86f3d0 (diff)
Merge branch 'master' of ch1p.io:homekit
Diffstat (limited to 'tools/clickhouse-backup.sh')
-rw-r--r--tools/clickhouse-backup.sh31
1 files changed, 0 insertions, 31 deletions
diff --git a/tools/clickhouse-backup.sh b/tools/clickhouse-backup.sh
deleted file mode 100644
index 6e938e4..0000000
--- a/tools/clickhouse-backup.sh
+++ /dev/null
@@ -1,31 +0,0 @@
-#!/bin/bash
-
-DIR=/var/lib/clickhouse/backup
-MAX_COUNT=3
-NAME=backup_$(date -u +%Y-%m-%d)
-
-create() {
- local name="$1"
- clickhouse-backup create "$name"
-}
-
-del() {
- local name="$1"
- clickhouse-backup delete local "$name"
-}
-
-# create a backup
-create "$NAME"
-
-# compress backup
-cd "$DIR"
-tar czvf $NAME.tar.gz $NAME
-
-# delete uncompressed files
-del "$NAME"
-
-# delete old backups
-for file in $(ls -t "${DIR}" | tail -n +$(( MAX_COUNT+1 ))); do
- echo "removing $file..."
- rm "$file"
-done \ No newline at end of file