Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

how to restore a collection or collections in mongodb from an archive file?

I have created a dump in an archive file by the following command :

mongodump --archive=newcollection.1.archive --db neel --collection newcollection

While restoring with the mongorestore i am getting an error :the --db and --collection args should only be used when restoring from a BSON file.

I got the syntax from [https://docs.mongodb.com/manual/reference/program/mongorestore/#examples][1] .

I fired the following command :

mongorestore --archive=newcollection.1.archive  --db backup2.
like image 617
Neel Avatar asked Jan 13 '17 07:01

Neel


2 Answers

use --nsFrom and --nsTo

see example :

mongodump -h foo.com:27017 --db source_db_name --gzip --archive | mongorestore --drop -vvvvvv -h bar.com:27017 --nsFrom source_db_name.collection_name --nsTo destination_db_name.* --gzip --archive

the format for nsFrom and nsTo is database_name.collection_name, and you can use wildcards ( like i did for destination_db_name.* ) for the same

more info

like image 117
Edwin O. Avatar answered Sep 22 '22 01:09

Edwin O.


mongorestore  --archive=<filename>.archive
like image 21
Necessary Lion Avatar answered Sep 19 '22 01:09

Necessary Lion