How to remove duplicate record in MongoDB 3.x?

Question

I tried

dropDups: true

but it is not working, is there any other way to remove duplicates from mongo collection?

And how to assign unique key to particular field?

Possible duplicate of [Remove duplicate in MongoDB](http://stackoverflow.com/questions/35707496/remove-duplicate-in-mongodb) — sidgate, Mar 31 '17 at 11:27

score 1 · Accepted Answer · answered Mar 31 '17 at 12:30

1

dropDupes is deprecated after 2.7

You can go for Aggregation and write script to remove dups. Or else you can get a dump of that collection then remove all documents from that old collection. after that add unique index to the collection and then restore the collection back. mongoresore will not add duplicate collections.

answered Mar 31 '17 at 12:30

Advay Umare

432
10
23

*"add duplicate collections"* did you mean to write *add duplicate records*? – ʰᵈˑ Mar 31 '17 at 12:33

How to remove duplicate record in MongoDB 3.x?

1 Answers1