|
|
# Backup
|
|
|
# Backup
|
|
|
|
|
|
Se connecter au container docker
|
|
|
``` bash
|
|
|
|
|
|
```bash
|
|
|
docker exec -it pamn_server_database-ram_1 /bin/sh
|
|
|
```
|
|
|
|
|
|
ou pour la prod :
|
|
|
``` bash
|
|
|
|
|
|
```bash
|
|
|
docker exec -it ram_database-ram_1 bash
|
|
|
```
|
|
|
|
|
|
Exporter la database
|
|
|
``` bash
|
|
|
|
|
|
```bash
|
|
|
mkdir /dump
|
|
|
mongodump --authenticationDatabase admin --username root --password PASSWORD -d ram -h localhost
|
|
|
Pour la recette et la production :
|
... | ... | @@ -18,55 +22,69 @@ mongodump --authenticationDatabase admin --username root -d ram -h localhost |
|
|
```
|
|
|
|
|
|
Copier le dump hors du container
|
|
|
``` bash
|
|
|
|
|
|
```bash
|
|
|
docker cp <containerId>:/dump /host/path/target
|
|
|
```
|
|
|
|
|
|
# Restore
|
|
|
# Restore
|
|
|
|
|
|
Des dumps de la base sont disponibles [ci-dessous](https://forge.grandlyon.com/web-et-numerique/pamn_plateforme-des-acteurs-de-la-mediation-numerique/pamn_server/-/wikis/bdd/Backup-and-restore-MongoDB#dump). Dézipper le dump dans un répertoire.
|
|
|
|
|
|
Trouver l'id du container pamn_server_database-ram_1
|
|
|
``` bash
|
|
|
|
|
|
```bash
|
|
|
docker ps
|
|
|
```
|
|
|
|
|
|
Copier le dump dans le container
|
|
|
|
|
|
```
|
|
|
docker cp <path_to_dump_folder> <container id>:/dump
|
|
|
```
|
|
|
|
|
|
Se connecter au container docker
|
|
|
``` bash
|
|
|
|
|
|
```bash
|
|
|
docker exec -it pamn_server_database-ram_1 bash
|
|
|
```
|
|
|
|
|
|
Si besoin, vider certaines collections de la base avant d'importer les nouvelles données (cf. commande ci-dessous).
|
|
|
|
|
|
Restaurer la database
|
|
|
``` bash
|
|
|
|
|
|
```bash
|
|
|
mongorestore --authenticationDatabase admin --username root --password MONGO_ROOT_PASSWORD -d ram ./dump/ram
|
|
|
Pour la recette et la production :
|
|
|
mongorestore --authenticationDatabase admin --username root -d ram ./dump/ram
|
|
|
```
|
|
|
|
|
|
Si on a restauré les données de prod des users, désactiver le MAIL_TOKEN du .env pour ne pas leur envoyer d'email (ou vider les emails de la collection des users, ou remplacer la collection des users par des users de tests).
|
|
|
|
|
|
# Useful cmd
|
|
|
|
|
|
Delete all documents of collection
|
|
|
``` bash
|
|
|
|
|
|
```bash
|
|
|
mongo admin -u root -p MONGO_ROOT_PASSWORD
|
|
|
use ram
|
|
|
db.structures.remove({})
|
|
|
```
|
|
|
|
|
|
Count all documents of collection
|
|
|
``` bash
|
|
|
|
|
|
```bash
|
|
|
mongo admin -u root -p MONGO_ROOT_PASSWORD
|
|
|
use ram
|
|
|
db.structures.count()
|
|
|
```
|
|
|
|
|
|
# Dump
|
|
|
|
|
|
| Name | Date | File |
|
|
|
| ------ | ------ | ------ |
|
|
|
|------|------|------|
|
|
|
| Update structure | 10/03/2021 | [dump.zip](uploads/adfa0327ff52782f83f08104fd38607e/dump.zip) |
|
|
|
| Update aptic structures | 25/02/2021 | [dump.zip](uploads/8ad0210e90109072d199912a531a88ba/dump.zip)|
|
|
|
| Update aptic structures | 25/02/2021 | [dump.zip](uploads/8ad0210e90109072d199912a531a88ba/dump.zip) |
|
|
|
| WorkShop + Wifi + typeStructure + hours clean | 11/02/2021 | [dump.zip](uploads/26f690ca6967bc3927246517012a654b/dump.zip) |
|
|
|
| Last update | 07/12/2021 | [dump_06122021.7z](uploads/8923b7eb7b02624f1ac1bbc755944bab/dump_06122021.7z) |
|
|
|
|