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 7 · Accepted Answer · edited Oct 04 '19 at 09:29

7

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
9

answered Jun 20 '17 at 11:59

tronic

439
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.

How to run mongo db script on remote server?

2 Answers2

Linked