... | ... | @@ -43,10 +43,14 @@ drwxr-xr-x 6 federicosismondi staff 192B Mar 24 21:36 orion-carouge |
|
|
# How to back up mysql data? (for keyrock)
|
|
|
WIP
|
|
|
|
|
|
# How to back up CrateDB?? (used by QuantumLeap)
|
|
|
# How to back up CrateDB? (used by QuantumLeap)
|
|
|
|
|
|
You can do a backup of a particular table with the following command:
|
|
|
`COPY "mtcarouge"."etdevice" to directory '/home/backup/' with (compression='gzip');`
|
|
|
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. Create the backup for this table: `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.
|
|
|
|
|
|
## Other operations on CrateDB
|
|
|
|
... | ... | |