[MONGODB] install and import - fourslickz/notes GitHub Wiki

apt-get install mongodb

wget -qO - https://www.mongodb.org/static/pgp/server-6.0.asc | apt-key add -
apt-get install gnupg
echo "deb [ arch=amd64,arm64 ] https://repo.mongodb.org/apt/ubuntu focal/mongodb-org/6.0 multiverse" | tee /etc/apt/sources.list.d/mongodb-org-6.0.list
apt-get install -y mongodb-mongosh

mongosh "mongodb://mongodb0.example.com:28015" --username alice --authenticationDatabase admin

---

CREATE USER

mongo

use admin

db.createUser(
  {
    user: "adminUser",
    pwd: "katana",
    roles: [ { role: "userAdminAnyDatabase", db: "admin" } ]
  }
)


db.createUser(
  {
    user: "blackNinja",
    pwd: "shuriken",
    roles: [ { role: "readWrite", db: "dojo" } ]
  }
)

use arts

db.createUser(
  {
    user: "greenNinja",
    pwd: "shuriken",
    roles: [ { role: "readWrite", db: "arts" } ],
    mechanisms:[  
     "SCRAM-SHA-1"
    ]
  }
)

use admin

db.getUsers()

use admin;
db.grantRolesToUser('devA', ['readWriteAnyDatabase']);
db.grantRolesToUser('devB', ['readWriteAnyDatabase']);

use admin;
db.grantRolesToUser('devB', [{ role: 'readWrite', db: 'client' }]);

---

AUTH

mongo --host localhost -u blackNinja -p shuriken --authenticationDatabase admin

---

DUMP

mongodump --forceTableScan --host yourhost --port 27017 -u yourusername -p yourpassword --db yourdb --out yourbackupdir

---

RESTORE

mongorestore -d yourdatabase ./yourbackupdir/dbdir

mongorestore --host yourhost --port 27017 -u yourusername -p yourpassword -d yourdatabase ./yourbackupdir/dbdir

---

sudo mongoimport --db newdb --collection restaurants --file primer-dataset.json

composer require jenssegers/mongodb