Clickhouse backup

sasicodesHOBBY

10 months 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

sasicodesHOBBY

10 months ago

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

brodyEMPLOYEE

9 months 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 • 10 months ago

brodyEMPLOYEE

9 months ago

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

sasicodesHOBBY

9 months 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>

brodyEMPLOYEE

9 months ago

Glad to hear it!

Status changed to Solved brody • 10 months ago