Question

Connect mongorestore to managed mongo database

Posted October 6, 2021 42 views
MongoDBDigitalOcean Managed MongoDB Database

I have setup a managed mongodb database in DO. I am able to successfully connect with compass but i need to use mongorestore to upload my backup. Here is the command and the error i am receiving. Kindly help!

mongorestore –uri=“mongodb+srv://doadmin:XXX@prod-cogito-mongo-b1299a8a.mongo.ondigitalocean.com/cogitoprod?authSource=admin&replicaSet=prod-cogito-mongo” –ssl –sslCAFile /home/pratik/Downloads/mongo-cert/ca-certificate.crt -d=cogitoprod –dryRun -v /home/pratik/db-backup/mongo/test

2021-10-06T10:49:35.390+0530 error connecting to host: could not connect to server: connection() error occured during connection handshake: dial tcp: i/o timeout

We are getting only the root certificate CRT from DO it seems there is another option –sslPEMKeyFile, do i need to use that as well if then how to get this pem file from the root cert.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
1 answer

Hi @cradmn2021,

You can use the below mongodump and mongorestore command to back and restore to MongoDB managed database cluster.

mongodump --uri "mongodb+srv://<your username>:<your password>@db-mongodb-xxx-xxxxxx-xxxxxxx.mongo.ondigitalocean.com/<dbname>?authSource=admin&replicaSet=db-mongodb-xxx-xxxxxx&tls=true&tlsCAFile=ca-certificate.crt"

mongorestore --uri "mongodb+srv://<your username>:<your password>@db-mongodb-xxx-xxxxxx-xxxxxxx.mongo.ondigitalocean.com/<dbname>?authSource=admin&replicaSet=db-mongodb-xxx-xxxxxx&tls=true&tlsCAFile=ca-certificate.crt" dump/<dbname>

Feel free to check MongoDB managed database import article :
https://docs.digitalocean.com/products/databases/mongodb/how-to/import-collections/

Also, make sure to add local machine/droplet IP from where you are going to execute this command to MongoDB managed database trusted source.

https://docs.digitalocean.com/products/databases/mongodb/how-to/secure/

I hope this helps!

Regards,
Rajkishore