How to run mongo db script on remote server?

Question

how to run a Mongo db script on a remote server?

I know below command can be used for the same on local as mentioned here:How to execute mongo commands through shell scripts?

mongo < yourFile.js

I want to run this script on a remote server

mongodb:uri:mongodb://user:password@mongodb01d.mydomain.com:27017/mydb

Did you try connecting with the shell? What does this have to do with spring? — Neil Lunn, Jun 20 '17 at 10:06
There is no direct use of spring to push this script.i will be using spring to fetch the contents later.Not tried with shell — shabinjo, Jun 20 '17 at 11:59

score 9 · Accepted Answer · edited Oct 04 '19 at 09:29

9

With Mongo on local machine :

 mongo -u <user> -p <password> mongodb01d.mydomain.com:27017/mydb <yourFile.js>

edited Oct 04 '19 at 09:29

DamienzOnly

88
1
10

answered Jun 20 '17 at 11:59

tronic

459
2
11

1

It works..Thanks! mongo -u user -p password mongodb01d.mydomain.com:27017/mydb < yourFile.js -changed for better file read from the path where 'yourFile.js' exist. – shabinjo Jun 20 '17 at 12:12
what about on remote server ? – Youssef Boudaya May 27 '21 at 13:16

score 2 · Answer 2 · edited Jan 29 '20 at 13:57

It might be a little bit off topic, but in case you want to / have to use Powershell for a lack of options, you can run:

(Get-Content yourFile.js) | & mongo.exe 'mongodb://user:password@mongodb01d.mydomain.com:27017/mydb'

or

"print('Hello');print('Hello')" | & mongo.exe 'mongodb://user:password@mongodb01d.mydomain.com:27017/mydb'

or

& 'mongo.exe' 'mongodb://user:password@mongodb01d.mydomain.com:27017/mydb' --eval "print('Hello');print('Hello')"

I had some difficulties with $regex, because Powershell interpreted it as a variable, so I had to use `$regex (with an additional backtick) instead.

Ashraf Sarhan · Answer 3 · 2023-04-24T22:33:47.570

For standalone mongo setup (single node)

mongo -u <user> -p <password> mongodb://HOST_IP:27017/DB_NAME --eval 'MONGO_QUERY'

Example:

mongo mongodb://127.0.0.1:27017/test --eval 'db.collection.count()'

For clustered mongo setup (Replicaset with multiple nodes)

mongo -u <user> -p <password> mongodb://NODE_1_IP:27017,NODE_2_IP:27017,NODE_3_IP:27017/DB_NAME?replicaSet=RS_ID --eval 'MONGO_QUERY'

Example:

mongo mongodb://127.0.0.1:27017,127.0.0.2:27017,127.0.0.3:27017/test?replicaSet=rs0 --eval 'db.collection.count()'

PS: The user/pass in the above examples have been ignored but you need to add them if mongo has to auth.

How to run mongo db script on remote server?

3 Answers3

Linked