v.23.4Improvement

Added Support for BACKUP ALL Command in ClickHouse

Official CH changelog text
Added support for BACKUP ALL command which backups all tables and databases, including temporary and system ones. #48189 (Vitaly Baranov).
Added support for the BACKUP ALL command which allows backing up all tables and databases, including temporary and system ones.

Why it matters

This feature enables users to create a comprehensive backup of the entire ClickHouse instance, covering all user, temporary, and system databases and tables. It simplifies backup processes by eliminating the need to specify each database or table individually, ensuring complete data protection and easier disaster recovery.

How to use it

Use the BACKUP ALL command in your SQL query to initiate a full backup of all databases and tables. For example:

BACKUP ALL TO 'backup/dir/path'

This command will include temporary and system tables in the backup.

Related resources

PreviousNext