clickhouse-backup selective create_remote \ restore_remote

create.sh

#!/bin/bash
backup_date=$(date +%Y-%m-%d-%H-%M-%S)
table_patterns=$1 # for example table_patterns="ns_v2.t_agg_page_h0?_local"
backup_name="full-$backup_date"
backup_command="create_remote --tables=$table_patterns $backup_name"

echo "RUN ${backup_command}"
echo "{\"command\":\"${backup_command}\"}" | curl -XPOST "http://localhost:7171/backup/actions" --data-binary=@-
while [[ "0" == $(curl -s "http://localhost:7171/backup/status" | grep -F "${backup_command}" | grep -c "success|error") ]]; do
  printf "."
  sleep 0.5
done
echo "RESULT"
curl -s "http://localhost:7171/backup/actions" | grep -F "${backup_command}"

restore.sh

#!/bin/bash
backup_name=$1
table_patterns=$2
1backup_command="restore_remote --rm --tables=$table_patterns $backup_name"

echo "RUN ${backup_command}"
echo "{\"command\":\"${backup_command}\"}" | curl -XPOST "http://localhost:7171/backup/actions" --data-binary=@-
while [[ "0" == $(curl -s "http://localhost:7171/backup/status" | grep -F "${backup_command}" | grep -c "success|error") ]]; do
  printf "."
  sleep 0.5
done
echo "RESULT"
curl -s "http://localhost:7171/backup/actions" | grep -F "${backup_command}"