Mongo in Docker

import csv file into mongodb:

                
mongoimport --host aws-us-west-2-portal.0.dblayer.com --port 99999 --db banks --collection list --ssl --sslAllowInvalidCertificates -u user -p mypass --type csv --headerline --file banklist.csv

import JSON file into mongodb:

mongoimport --db dbName --collection collectionName fileName.json

If JSON file is too big, need to change it to JSONarray, like

mongoimport --db dbName --collection collectionName fileName.jsonarray --jsonArray

2021年2月24日：(February 24, 2021)

Get mongo from docker:

                docker pull mongo

Create run_mongodb.sh and run it (postgresql use port 5432, while mongo use port 27017):

                    $ cat run_mongpdb.sh 
                        #!/bin/bash
                        
                        export VOLUME='/home/user/code'
                        
                        docker run -itd \
                            --name mongodb \
                            --publish 4514:27017 \
                            --publish 90:22 \
                            --volume ${VOLUME}:/code \
                            mongo

Start mongo shell from docker:

                    docker exec -it mongodb bash

Then type mongo

The following information manily from Tutorials Point.

Show existing databases:

                    show dbs

Show current database:

db

Change database (if not exist, create it):

                    use DATABASE_NAME

Like use sinnud

Drop database:

                    db.dropDatabase()

Like drop database "sinnud":

                    use sinnud
db.dropDatabase()

Show collections:

                    use db
show collections

Show data in collection:

                    use db
db.mycol.find()