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

mongodb mongodump mongorestore
Neel picture Neel · Jan 13, 2017 · Viewed 9.6k times · Source

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.

Answer

Edwin O. picture Edwin O. · Dec 28, 2017

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

Related questions

MongoDB mongorestore failure: locale::facet::_S_create_c_locale name not valid

I created a dump with mongodump on computer A (ubuntu 12.04 server). I moved it to computer B (ubuntu 12.04 server) and typed: mongorestore -db db_name --drop db_dump_path It failed and it reported: connected to: 127.0.0.1 terminate called after throwing …

Read More
How to use the dumped data by mongodump?

I have used mongodump to dump my database of mongodb, it created some bson files under dump/mydb But I don't know how to use them. I tried mongoimport, but seems it can't import bson data. Then how to use …

Read More
MongoDb: How to import dump data from .gz file?

I want to import dump data from my .gz file. Location of file is home/Alex/Documents/Abc/dump.gz and the name of db is "Alex". I have tried mongorestore --gzip --db "Alex" /home/Alex/Documents/Abc/dump.gz …

Read More