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

Question

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.

you can't use the --db param when restoring from archive, just use mongorestore --archive=newcollection.1.archive — felix, Jan 13 '17 at 07:37
And moreover i want to restore data in some specified database — Neel, Jan 13 '17 at 07:44
then you can't use --archive flag. You should do a classic mongodump and work with the BSON files — felix, Jan 13 '17 at 07:48
You mean to say i can't restore into some other database from archive file? — Neel, Jan 13 '17 at 08:09
as of mongodb 3.4, yes. An issue has been openend for this, see https://jira.mongodb.org/browse/TOOLS-1073 — felix, Jan 13 '17 at 09:11

score 8 · Answer 1 · answered Dec 28 '17 at 20:56

8

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

answered Dec 28 '17 at 20:56

Edwin O.

4,998
41
44

The example from the docs was giving me the `E11000 duplicate key error collection: db.collection index: _id_ dup key` error. Your answer gave me the hint to remove quotes from `--nsFrom` and `--nsTo`, and the error went away. – KalenGi Jul 13 '20 at 10:29

score 1 · Answer 2 · answered Feb 12 '22 at 19:29

1

mongorestore  --archive=<filename>.archive

answered Feb 12 '22 at 19:29

A J

191
3
4

score 0 · Answer 3 · answered Dec 09 '22 at 06:17

0

when you want to restore a mongodb archived database go to file path and write

mongorestore --archive=filename.archive

and then press enter it will restore all data of from archive file to your local database.

answered Dec 09 '22 at 06:17

Ahad

49
1
6

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

3 Answers3