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.
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.
Hi @cradmn2021,
You can use the below mongodump and mongorestore command to back and restore to MongoDB managed database cluster.
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