... | ... | @@ -47,7 +47,7 @@ WIP |
|
|
|
|
|
You can do a backup of a particular table (here in our case, a table of the Carouge pilot) with the following commands:
|
|
|
1. Go to the Docker container for CrateDB: `docker exec -it db-crate bash`
|
|
|
1. Go to the CrateDB GUI at [http://test.naiades-project.eu:4200/](CrateDB GUI). This graphical user interface is only available through the VPN; there is no public access for obvious security reasons.
|
|
|
1. Go to the CrateDB GUI at [http://test.naiades-project.eu:4200/](http://test.naiades-project.eu:4200/). This graphical user interface is only available through the VPN; there is no public access for obvious security reasons.
|
|
|
1. Create the backup for this table on the console shown on the CrateDB GUI: `COPY "mtcarouge"."etdevice" to directory '/home/backup/' with (compression='gzip');`
|
|
|
1. Copy the backup outside the container: `docker cp db-crate:/orion-carouge/ ~/backup/`
|
|
|
1. Copy the backup outside the virtual machine hosting the NAIADES IoT platform using scp or WinSCP.
|
... | ... | |