How to call MongoDB commands using .bat file

Question

I'm trying to execute MongoDB command (for create DB) using .bat file.

For that I've tried:

cd C:\Program Files\MongoDB\Server\3.4\bin
mongo 
mongo --eval "use MyDatabase"
pause

But it gives an error missing ; before statement @(shell eval):1:4
How can I solve this issue?

Side: I've already gone through MongoDB SyntaxError: missing ; before statement @(shell)

Sparw · Accepted Answer · 2017-12-18T08:16:34.727

11

Can you try with :

cd Program Files\MongoDB\Server\3.4\bin
mongo.exe 
mongo.exe --eval "use MyDatabase"
pause

I am using a .bat file which works properly and contains this

cd \Program Files\MongoDB\Server\3.2\bin
mongod.exe
pause

EDIT

I tested a file like this and it works fine (create db, collection and document)

mongodb.bat

cd \Program Files\MongoDB\Server\3.2\bin
mongo.exe db-mydb --eval "db.yourCollection.insert({key:'value'});"
pause

EDIT 2

If you want to run your .bat file on the background, i have made a .VBS file which works properly

mongodb.VBS

Set WshShell = CreateObject("WScript.Shell") 
WshShell.Run chr(34) & "C:\Path\To\Your\mongodb.bat" & Chr(34), 0
Set WshShell = Nothing

Hope it helps

edited Dec 18 '17 at 08:16

answered Dec 30 '16 at 09:25

Sparw

2,688
1
15
34

It's not showing any error, but it doesn't create a DB – Divyang Desai Dec 30 '16 at 09:40
1

If you want to create a new database, I think you have to insert a new document inside – Sparw Dec 30 '16 at 09:45
1

You mean collection? I've tried with add `mongo.exe --eval "db.createCollection('testcollecation')"` but no luck :( – Divyang Desai Dec 30 '16 at 09:46
Can you try with something like this ? mongo.exe --eval "db.yourCollection.insert({"key":"value"})" – Sparw Dec 30 '16 at 09:49

score 3 · Answer 2 · edited Jun 20 '20 at 09:12

Put this code in your bat file.
It'll start and activate the mongodb in 2 different admin privileged cmd windows.
Please check the paths before to adjust to your environment.

START "runas /user:administrator" cmd /K "cd C:\Program Files\MongoDB\Server\3.4\bin & mongod.exe --dbpath c:\data\db"

TIMEOUT /T 10 START

START "runas /user:administrator" cmd /K "cd C:\Program Files\MongoDB\Server\3.4\bin & mongo.exe "

score 0 · Answer 3 · answered Apr 06 '20 at 05:59

Try this:

cd C:\Program Files\MongoDB\Server\3.4\bin
mongo.exe 
mongo.exe --eval "use MyDatabase"
pause

or use a text file script.txt containing your commands and write batch file as:

cd C:\Program Files\MongoDB\Server\3.4\bin
mongo.exe mydb < script.txt

can use full path if file is at different location.

How to call MongoDB commands using .bat file

3 Answers3