By cradmn2021
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/cogito_prod?authSource=admin&replicaSet=prod-cogito-mongo” --ssl --sslCAFile /home/pratik/Downloads/mongo-cert/ca-certificate.crt -d=cogito_prod --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.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.