Skip to main content

Clickhouse Backup

Follow these steps in clickhouse server.

  1. Download Clickhouse-backup-utility.zip from the link provided in email.
  2. Make directory in path /motadata:

mkdir clickhouse-backup

  1. Upload Clickhouse-backup-utility.zip and unzip it in path /motadata/clickhouse-backup:

unzip Clickhouse-backup-utility.zip

  1. After unzip, following files should be visible:
  • Clickhouse_backup
  • config.yml
  1. Add 775 permission to the clickhouse_backup

chmod 775 clickhouse_backup

  1. Open config.yml file and enter values w.r.t. your clickhouse configuration.

make changes in config file

Set up FTP Settings

  1. Take the backup in a new file. Keep the file name of your choice.

/motadata/clickhouse-backup/clickhouse-backup create -c/motadata/clickhouse-backup/config.yml {file name of your choice}

  1. When backup is complete, your file will appear in /motadata/clickhouse/backup’. If you have set up FTP information in config.yml, motadata will create a copy of backup in shared server path.

Troubleshooting

In case if there is any interruption while taking the backup, do following step:

  1. Remove all folders in /motadata/motadata/shadow.
  2. Follow step 7