... | ... | @@ -49,7 +49,7 @@ You can do a backup of a particular table (here in our case, a table of the Caro |
|
|
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/](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 container: `docker cp db-crate:/home/backup/ ~/backup/`
|
|
|
1. Copy the backup outside the virtual machine hosting the NAIADES IoT platform using scp or WinSCP.
|
|
|
|
|
|
## Other operations on CrateDB
|
... | ... | |