MongoDb import JSON data to collection using redirection operator

Question

I have set up `mongo' DB on my machine using the following docker-compose file.

version: "3.1"
services:
  mongo:
    image: mongo
    restart: always
    environment:
      MONGO_INITDB_ROOT_USERNAME: root
      MONGO_INITDB_ROOT_PASSWORD: example
    volumes:
      - ${PWD}/data:/usr/src/data

Now, I want to insert sample data into a collection named books using the below command

mongo books < booksJson.js

But when I execute this command I am getting the following error

MongoDB shell version v4.4.1
connecting to: mongodb://127.0.0.1:27017/books?compressors=disabled&gssapiServiceName=mongodb
Implicit session: session { "id" : UUID("57936227-aa22-4d5f-841b-59788847bc3c") }
MongoDB server version: 4.4.1
WriteCommandError({
        "ok" : 0,
        "errmsg" : "command insert requires authentication",
        "code" : 13,
        "codeName" : "Unauthorized"
})
bye

Below are the contents of my booksJson.js file.

db.books.insert([
{
     title: 'xyz',
     test: 1
}
])

Any pointers towards how to use mongo.exe to import JSON data using a JavaScript file and redirection operator?

I think you have to tell mongo which database you want to insert and add credentials for that db. for example: mongo --db library -u username -p password books < booksJson.js — MahanTp
– MahanTp, Commented Oct 3, 2020 at 7:44
See this post for: How to load multiple js files using mongo shell. — prasad_
– prasad_, Commented Oct 3, 2020 at 10:17
@Mahan it looks like --db option is not valid. getting error : Error parsing command line: unrecognised option '--db' — user2243747
– user2243747, Commented Oct 4, 2020 at 2:06

user2243747 · Accepted Answer · 2020-10-04 05:23:16Z

1

@Prasad's comment/pointer helped to find out the solution.

I was able to import data using the following command.

mongo localhost:27017/bookdb  --authenticationDatabase "admin" -u root -p example  < booksJson.js

I have to mention authinticationDatabase flag in order to get it to work.

answered Oct 4, 2020 at 5:23

user2243747

3,0078 gold badges47 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MongoDb import JSON data to collection using redirection operator

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related