execute restore entire-db
Use this command to perform a full restoration of the ClickHouse database from a previously saved backup file <saved-filename>. The restore operation retrieves the backup from the specified source and restores it to the local device.
- This operation will overwrite all existing ClickHouse data on the local device. Any previously stored databases and tables will be permanently replaced by the contents of the backup file.
- The backup file will be considered valid, and restoration will proceed only if the following conditions are met
- The system mode matches between the source and target devices
Both devices are running the same firmware version.
- The local device has sufficient memory and storage space available
-
When a connected sensor device is restored, the center registers it as a new sensor device with a new sensor ID, and all data will be synced for this new device. The original device and its associated data are then marked as obsolete.
Syntax
execute restore entire-db {disk|scp|ftp|tftp} <saved-filename> <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. |
|