Cannot import mongodb

Question

I tried mongo import like this

mongoimport -d test -c foo importfile.json
mongoimport --host localhost --db local --collection lecturer --type json --file temp.json --headerline --upsert

and I've got same error message "Syntax Error: missing ; before statement (shell):1" what's wrong with my code & how to import if my data stored in C:\Documents and Settings\User\Desktop ?? please help, thank's in advance

Closely related and probably covered by http://stackoverflow.com/questions/11041614/cant-export-mongodb — paulmelnikow, Jun 15 '12 at 00:04

score 90 · Answer 1 · answered Jun 15 '12 at 01:40

90

mongoimport is intended to run in command prompt and not in the mongo shell. Try exiting out of the shell and running the command.

answered Jun 15 '12 at 01:40

user1295798

1,034
6
3

1

I already tried run in command prompt like this below? [http://i1066.photobucket.com/albums/u415/zack_syah/commandprompt.png](http://i1066.photobucket.com/albums/u415/zack_syah/commandprompt.png) what's wrong and command prompt doesn't recognize syntax? Can you show the step how import with image so I can understand – user1052073 Jun 15 '12 at 06:46
6

"mongoimport is not recognized as a command" means that mongoimport.exe is not in your current path. The ./ syntax with forward path separators is for unix; Windows uses \. Assuming c:\mongodb\bin is where you have saved the MongoDB files, you should be able to run from the c:\mongodb\bin\dump directory using either the full path to mongoimport: `c:\mongodb\bin\mongoimport.exe -d test -c foo importfile.bson` ...or the relative path: `..\mongoimport.exe -d test -c foo importfile.bson`. – Stennie Jun 15 '12 at 11:42
1

omg. this is also true if you're trying to setup an mlab connection, for anyone else stuck here. geez, thanks! – Jona May 08 '16 at 20:08
how do you pass in creds with this? I'm getting 'unauthorized' when I try to import otherwise – Sinaesthetic Jan 08 '17 at 23:06
@user1052073 jesus dude, I sepnt over one hour looking for why i couldnt import the file and I was trying to do it from the shell. I cant believe there was no documentation stating that this command is supposed to be run from CMD. Thanks for the help bro you da real MVP – Lostaunaum Jan 19 '17 at 18:32

score 3 · Answer 2 · answered Mar 05 '16 at 12:05

3

One solution is:

First, in cmd, change to the directory containing mongoexport.exe file, then type your command.

C:\Program Files\MongoDB\Server\3.2\bin> .\mongoexport.exe -d foo -c bar -o output.json

answered Mar 05 '16 at 12:05

Yas

4,957
2
41
24

score 3 · Answer 3 · edited Apr 11 '20 at 19:58

3

mongoimport is to be run on the terminal and not inside the mongo shell. To run mongoimport in terminal, you will need to install the same. On ubuntu, you can do : apt-get install mongo-tools Hope this helps :)

edited Apr 11 '20 at 19:58

Rot-man

18,045
12
118
124

answered Jun 15 '18 at 09:45

Kriti Singh

31
1

score 2 · Answer 4 · answered Dec 12 '15 at 22:54

I had the same problem and was able to figure it out after a brief struggling and googling. 1. Navigate to the bin directory in command prompt (cd c:..\bin) 2. Run the mongoimport command but you have to specify the full path of your json file. That solves the problem

score 1 · Answer 5 · answered Mar 29 '13 at 02:15

1

try to use CSV is a good.

mongoimport -d mydb -c things --type csv --file locations.csv --headerline --upsert

You can convert by ms excel.

answered Mar 29 '13 at 02:15

Krit Pakarat

19
1

score 0 · Answer 6 · answered Jun 05 '17 at 05:58

0

Open the "Mongo/Server/3.4/bin" folder of mongo db in another command window and try again.It Will work.

answered Jun 05 '17 at 05:58

Sakthikanth

139
7

score 0 · Answer 7 · answered Jun 02 '19 at 05:50

0

Open a new terminal or command prompt within the location of the file you want to import and it should work. It will not work on MongoDB shell

answered Jun 02 '19 at 05:50

Rahi Javaid

1

score 0 · Answer 8 · answered Mar 20 '23 at 05:54

1.) Download the MongoDB Database Tools from MongoDB official Website and Unzip the folder

2.) Copy the json file which contains the data to be imported in the same folder as mongoimport.exe

3.) For Windows open the command prompt and run cd (path to folder with mongoimport.exe)

4.) run command .\mongoimport.exe import_data.json -d database_name -c collection_name --jsonArray

example

Cannot import mongodb

8 Answers8

Linked

Related