下载安装

wget https://github.com/Altinity/clickhouse-backup/releases/download/v2.6.41/clickhouse-backup-linux-amd64.tar.gz
tar xf clickhouse-backup-linux-amd64.tar.gz
cp build/linux/amd64/clickhouse-backup /usr/local/bin/

创建配置文件

mkdir -p /etc/clickhouse-backup
clickhouse-backup default-config > /etc/clickhouse-backup/config.yml

编辑配置文件

clickhouse:
    username: default
    password: ""
    host: x.x.x.x
    port: 9001

创建备份，生成的备份目录在clickhose-server数据目录比如/data/clickhouse/backup

clickhouse-backup create 202512080949