clickhouse-backup.sh

Backup / restore small ClickHouse databases.

For typical ClickHouse databases, please use clickhouse-backup.

Install

sudo wget -O /usr/local/bin/clickhouse-backup.sh \
  https://raw.githubusercontent.com/mahadana/clickhouse-backup.sh/main/clickhouse-backup.sh
sudo chmod a+x /usr/local/bin/clickhouse-backup.sh

Usage

clickhouse-backup.sh -d dbname backup > dumpfile

clickhouse-backup.sh -d dbname restore < dumpfile

clickhouse-backup.sh --help

Caveats

This uses large amounts of /tmp space to backup / restore the database.