clickhouse-backup

最新推荐文章于 2024-06-18 19:30:59 发布

lwei_998

最新推荐文章于 2024-06-18 19:30:59 发布

阅读量929

点赞数 1

分类专栏： ClickHouse

本文链接：https://blog.csdn.net/lwei_998/article/details/119839595

版权

ClickHouse 专栏收录该内容

6 篇文章 3 订阅

订阅专栏

clickhouse-backup -v
Version:         1.0.0
Git Commit:      37f3bd78adec2aadc1de10f9323fe426a5e12dc4
Build Date:      2021-06-16

SELECT version()

Query id: 20eab3e5-347d-42fe-82a2-03459476a023

┌─version()─┐
│ 21.8.3.44 │
└───────────┘

# clickhouse-backup create -t=default.t
2021/08/21 14:35:10  info done                      backup=2021-08-21T06-35-10 operation=create table=default.t
2021/08/21 14:35:10  info done                      backup=2021-08-21T06-35-10 operation=create

DROP TABLE t

Query id: e6080c22-5661-4e61-b892-f9e43a95e3ff

Ok
 
 
clickhouse-backup restore 2021-08-21T06-35-10 -t=default.t
2021/08/21 14:40:51 error can't create table `default`.`t`: code: 57, message: 
Directory for table data store/c57/c5780d8a-7d5a-47a3-8578-0d8a7d5a37a3/ already exists after 1 times, please check your schema depencncies

去掉 ${backup_path}/2021-08-21T06-35-10/metadata/default/t.json 中的UUID
UUID '80ea6411-9c37-4d47-80ea-64119c374d47'

再次执行恢复
clickhouse-backup restore 2021-08-21T06-35-10 -t=default.t

SELECT count(1)
FROM t

Query id: 9e5ab872-4844-4aea-90a9-a071bb23e433
┌─count()─┐
│ 1000000 │
└─────────┘