CODEWITHSUNDEEP
jsonmongodbmongoimport
user3306125
user3306125

Reputation: 215

MongoDB Bulk import using mongoimport from Windows folder

I have a lot of json files in archive and i need to import them into mongo per one operation (i think that it might be in cycle). Have you any ideas about this?

Upvotes: 13

Views: 22731

Answers (4)

Hett
Hett

Reputation: 3824

You need to use mongorestore for recovery from dump, created by the mongodump

http://docs.mongodb.org/v2.6/reference/program/mongorestore/

for example

mongorestore --drop --oplogReplay mongodb/

Upvotes: 3

Михаил Кудрявцев
Михаил Кудрявцев

Reputation: 121

mongorestore is import all exported mongodb files

cd C:\Program Files\MongoDB\Server\4.0\bin
mongorestore.exe -d <db name> C:\Users\Mike\Downloads\myProject\

But if you really want to import all only meta json files without .bson

cd C:\Users\Mike\Downloads\myProject\
FOR %i IN (*.json) DO "C:\Program Files\MongoDB\Server\4.0\bin\mongoimport.exe" --db <db name> --collection %~ni --type json --file %i

This is sample work on windows 10

Upvotes: 4

Ahmed Hesham
Ahmed Hesham

Reputation: 19

You can use this:

FOR %i IN (<data folder>\*.json) DO mongoimport -d <database> -c <collection> --file %i

Upvotes: 0

Sumeet Kumar Yadav
Sumeet Kumar Yadav

Reputation: 12985

If you are in a Linux/Unix shell you can try

for filename in *; do mongoimport -d mydb -c $filename;  done

If you are on Windows: 

FOR %i IN (C:\mongodbData\*.json) DO mongoimport --db dbName --collection colection --type json --file %i

Upvotes: 25

Related Questions