Clickhouse backup

sasicodes
HOBBY

a year 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
HOBBY

a year ago

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

brody
EMPLOYEE

a year 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 • 11 months ago

brody
EMPLOYEE

a year ago

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

sasicodes
HOBBY

a year 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

a year ago

Glad to hear it!

Status changed to Solved brody • 11 months ago

Clickhouse backup - Railway Help Station