How to copy a collection from one database to another in MongoDB

by

The best way is to do a mongodump then mongorestore. You can select the collection via:

mongodump -d some_database -c some_collection

[Optionally, zip the dump (zip some_database.zip some_database/* -r) and scp it elsewhere]

Then restore it:

mongorestore -d some_other_db -c some_or_other_collection dump/some_collection.bson

Existing data in some_or_other_collection will be preserved. That way you can “append” a collection from one database to another.

Prior to version 2.4.3, you will also need to add back your indexes after you copy over your data. Starting with 2.4.3, this process is automatic, and you can disable it with --noIndexRestore.

More Related Contents:

  1. How to select a single field for all documents in a MongoDB collection?
  2. Clone a collection in MongoDB
  3. Find objects between two dates MongoDB
  4. MongoDB: Is it possible to make a case-insensitive query?
  5. How to update the _id of one MongoDB Document?
  6. MongoDB: count the number of items in an array
  7. How to remove a field completely from a MongoDB document?
  8. How to Model a “likes” voting system with MongoDB
  9. arrayFilters in mongodb
  10. MongoDB password with “@” in it
  11. MongoDB: How to query for records where field is null or not set?
  12. exclude fields in $lookup aggregation
  13. Mongo how to $lookup with DBRef
  14. Add some kind of row number to a mongodb aggregate command / pipeline
  15. How to enforce foreign keys in NoSql databases (MongoDB)?
  16. How do you query for “is not null” in Mongo?
  17. MongoDB: exception in initAndListen: 20 Attempted to create a lock file on a read-only directory: /data/db, terminating
  18. MongoDB ‘unable to find index for $geoNear query’
  19. MongoDB sort documents by array elements
  20. MongoDB won’t start after server crash
  21. How does sorting with an index work in MongoDB?
  22. How to use dot in field name?
  23. How to get multiple document using array of MongoDb id?
  24. Docker: change folder where to store docker volumes
  25. How to organise a many to many relationship in MongoDB
  26. Mongodb aggregation pipeline how to limit a group push
  27. How to check if an array field contains a unique value or another array in MongoDB?
  28. MongoDB index/RAM relationship
  29. MongoDB Single Document size limit is 16MB
  30. mongodb aggregate query isn’t returning proper sum on using $sum

Leave a Comment