execute backup entire-db

Use this command to create a full backup of the entire ClickHouse database and store it at the specified location <filename-to-be-saved>. The backup includes all databases, tables, and metadata except:

• System tables
• Temporary information and cache tables

Syntax

execute backup entire-db {disk|scp|ftp|tftp} <filename-to-be-saved> <server>[:ftp port] <user-name> <password>

Variable	Description	Default
disk	The local disk.
ftp	The FTP server.
scp	The SCP server.
tftp	The TFTP server.