| 语法 | BACKUP TABLE db.t TO Disk('backups', 't.zip')；RESTORE TABLE … FROM … |
|---|---|
| 范围 | TABLE / DICTIONARY / DATABASE，可按分区 PARTITION 备份 |
| 进度 | system.backups 的 status、num_files、total_size、error |
示例
示例
BACKUP TABLE analytics.events
TO Disk('backups', 'events-2024-07.zip');
RESTORE TABLE analytics.events
FROM Disk('backups', 'events-2024-07.zip');
SELECT status, num_files, formatReadableSize(total_size) AS size
FROM system.backups
ORDER BY start_time DESC LIMIT 5;备份目标要先在 storage_configuration 里定义好磁盘；对象存储备份依赖对应集成配置。