clickhouse设置备份路径

# vi /etc/clickhouse-server/config.d/backup_disk.xml
<clickhouse>
    <storage_configuration>
        <disks>
            <backups>
                <type>local</type>
                <path>/abce/backups/</path>
            </backups>
        </disks>
    </storage_configuration>
    <backups>
        <allowed_disk>backups</allowed_disk>
        <allowed_path>/abce/backups/</allowed_path>
    </backups>
</clickhouse>

:) SELECT
                                 name,
                                 path,
                                 formatReadableSize(free_space) AS free,
                                 formatReadableSize(total_space) AS total,
                                 formatReadableSize(keep_free_space) AS reserved
                             FROM system.disks
                             ;

SELECT
    name,
    path,
    formatReadableSize(free_space) AS free,
    formatReadableSize(total_space) AS total,
    formatReadableSize(keep_free_space) AS reserved
FROM system.disks

Query id: 873603ba-adeb-4ea1-a240-d6aff32f429a

┌─name────┬─path──────────────────────────┬─free──────┬─total──────┬─reserved─┐
│ backups │ /abce/backups/                │ 0.00 B    │ 0.00 B     │ 0.00 B   │
│ default │ /abce/clickhouse-server/abce/ │ 44.49 GiB │ 199.90 GiB │ 0.00 B   │
└─────────┴───────────────────────────────┴───────────┴────────────┴──────────┘

2 rows in set. Elapsed: 0.001 sec.

BACKUP TABLE|DATABASE table_name|abcebase_name TO Disk('<backup_location>', 'backupName.zip');

RESTORE TABLE|DATABASE table_name|abcebase_name FROM Disk('<backup_location>', 'backupName.zip')