search

Altinity / clickhouse-backup

Tool for easy backup and restore for ClickHouse® using object storage for backup files.
https://altinity.com
Other
1.25k stars 225 forks source link

Why is there no shadow or data directory generated after create? Only metadata #490

Closed hellonickyangdx closed 2 years ago

hellonickyangdx commented 2 years ago

drwxr-x--- 3 root root 4096 Aug 10 11:42 . drwxr-x--- 3 root root 4096 Aug 10 11:42 .. drwxr-x--- 3 root root 4096 Aug 10 11:42 metadata -rw-r----- 1 root root 587 Aug 10 11:42 metadata.json

clickhouse-backup tables

bigo.dwm_adhoc_beans_by_country 2.46MiB default
bigo.dwm_adhoc_beans_by_streamer 710.53MiB default
bigo.dwm_adhoc_by_country 1.29MiB default
bigo.dwm_adhoc_by_liveroom 1.52GiB default
bigo.dwm_adhoc_by_streamer 473.78MiB default

Slach commented 2 years ago

clickhouse-backup require direct access to the same /var/lib/clickhouse as clickhouse-server if you use docker / docker-compose use the same volume mounts

if you try to run clickhouse-backup on different remote host, don't do it, run clickhouse-backup on the same server with clickhouse-server and change /etc/clickhouse-backup/config.yml

clickhouse:
  host: 127.0.0.1
hellonickyangdx commented 2 years ago

Thank you very much. I succeeded