Clickhouse backup
sasicodes
HOBBYOP

2 years ago

We have clickhouse template deployed in the stack. We need to backup the data. We can connect the instance via GUIs. Please help

Solved

4 Replies

sasicodes
HOBBYOP

2 years ago

project/6f00d660-5d56-4413-b627-fe9f4895352f/service/b04479f7-c7da-48f3-a5d7-af44fef7ea44

brody
EMPLOYEE

2 years ago

This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.

Status changed to Open brody • over 1 year ago

brody
EMPLOYEE

2 years ago

Perhaps these docs are helpful? - https://clickhouse.com/docs/en/operations/backup

sasicodes
HOBBYOP

2 years ago

currently we wrote a cron to do the job. as we have millions of rows, using OFFSET and LIMIT for our use-case. Solved.

INSERT INTO FUNCTION
          s3(
            '${BUCKET_URL}/${fileName}',
            '${ACCESS_KEY_ID}',
            '${SECRET_ACCESS_KEY}',
            'CSV'
          )
SELECT * FROM <table>
brody
EMPLOYEE

2 years ago

Glad to hear it!

Status changed to Solved brody • over 1 year ago

Loading...