nlapshin

clickhouse-client --query="SELECT * FROM table FORMAT Native" > table.native
Native is the most efficient format 
CSV, TabSeparated, JSONEachRow are more portable: you may import/export data to another DBMS.

Dump of metadata:
clickhouse-client --query="SHOW CREATE TABLE table" --format=TabSeparatedRaw > table.sql

Restore of metadata:
clickhouse-client < table.sql

nlapshin

# Copy database from one server to another server
mongodump  --host <from_host> --db <from_db> --archive | mongorestore --host <to_host> --archive

# Restore database(or collection) to another database(or collection)
mongorestore --gzip --archive=${BACKUP_FILE_GZ} --nsFrom "${DB_NAME}.*" --nsTo "${DB_NAME_RESTORE}.*"

nlapshin

#!/bin/bash

set -e

echo "🧹 Remove old Docker (if exists)..."

sudo apt-get remove -y docker docker-engine docker.io containerd runc || true

echo "📦 Install dependencies..."