CODEWITHSUNDEEP
mongodb
Trevor Burnham
Trevor Burnham

Reputation: 77426

Delete everything in a MongoDB database

I'm doing development on MongoDB. For totally non-evil purposes, I sometimes want to blow away everything in a database—that is, to delete every single collection, and whatever else might be lying around, and start from scratch. Is there a single line of code that will let me do this? Bonus points for giving both a MongoDB console method and a MongoDB Ruby driver method.

Upvotes: 541

Views: 398217

Answers (18)

Solomon Botchway
Solomon Botchway

Reputation: 789

If you're using node js, you can drop all collections in every database like so:

//! USE WITH CAUTION: This code will drop all collections in every database
const mongo = new MongoClient(MONGO_URL)
const dbs = await mongo.db().admin().listDatabases()
for (const { name: dbName } of dbs.databases) {
    const db = mongo.db(dbName)
    const collections = await db.collections()

    for (const collection of collections) {
        try {
            await collection.drop() // Mongo won't let us drop the system collections so we catch and ignore those
        } catch (e) {}
    }
}

Upvotes: 0

Bogdan D
Bogdan D

Reputation: 5631

By compiling answers from @Robse and @DanH (kudos!), I've got the following solution which completely satisfies me:

db.getCollectionNames().forEach( function(collection_name) { 
  if (collection_name.indexOf("system.") == -1) 
       db[collection_name].drop();
  else  
       db[collection_name].remove({});
});

It cleans the database by dropping the user collections and emptying the system collections.

Upvotes: 24

bhv
bhv

Reputation: 5398

Here are some useful delete operations for mongodb using mongo shell

To delete particular document in collections: db.mycollection.remove( {name:"stack"} )

To delete all documents in collections: db.mycollection.remove()

To delete any particular collection : db.mycollection.drop()

to delete database : first go to that database by use mydb command and then

db.dropDatabase()

Upvotes: 16

Josh K
Josh K

Reputation: 28893

In the mongo shell:

use [database];
db.dropDatabase();

And to remove the users:

db.dropAllUsers();

Upvotes: 679

Selvakumar Ponnusamy
Selvakumar Ponnusamy

Reputation: 5563

db.getCollectionNames().forEach(c=>db[c].drop())

Upvotes: 43

sjas
sjas

Reputation: 19767

in case you'd need to drop everything at once: (drop all databases at once)

mongo --quiet --eval 'db.getMongo().getDBNames().forEach(function(i){db.getSiblingDB(i).dropDatabase()})'

Upvotes: 11

kevinadi
kevinadi

Reputation: 13805

In MongoDB 3.2 and newer, Mongo().getDBNames() in the mongo shell will output a list of database names in the server:

> Mongo().getDBNames()
[ "local", "test", "test2", "test3" ]

> show dbs
local  0.000GB
test   0.000GB
test2  0.000GB
test3  0.000GB

A forEach() loop over the array could then call dropDatabase() to drop all the listed databases. Optionally you can opt to skip some important databases that you don't want to drop. For example:

Mongo().getDBNames().forEach(function(x) {
  // Loop through all database names
  if (['admin', 'config', 'local'].indexOf(x) < 0) {
    // Drop if database is not admin, config, or local
    Mongo().getDB(x).dropDatabase();
  }
})

Example run:

> show dbs
admin   0.000GB
config  0.000GB
local   0.000GB
test    0.000GB
test2   0.000GB
test3   0.000GB

> Mongo().getDBNames().forEach(function(x) {
...   if (['admin', 'config', 'local'].indexOf(x) < 0) {
...     Mongo().getDB(x).dropDatabase();
...   }
... })

> show dbs
admin   0.000GB
config  0.000GB
local   0.000GB

Upvotes: 1

Sreeragh A R
Sreeragh A R

Reputation: 3021

I prefer

db.your_collection.remove({})

over

db.your_collection.drop()

If your collection was a special collection i.e a capped collection or a collection with one field marked as unique, dropping will clear the collection itself and when collection is again created it will be an ordinary collection. You will have to define the properties again. So use remove() to clear the documents without removing the collection and affecting the behavior of the collection.

Upvotes: 8

priya raj
priya raj

Reputation: 362

  1. List out all available dbs show dbs
  2. Choose the necessary db use
  3. Drop the database db.dropDatabase() //Few additional commands
  4. List all collections available in a db show collections
  5. Remove a specification collection db.collection.drop()

Hope that helps

Upvotes: 2

Antonio Bardazzi
Antonio Bardazzi

Reputation: 3246

use <dbname>
db.dropAllUsers()
db.dropAllRoles()
db.dropDatabase()

MongoDB db.dropDatabase() documentation explaining the modification introduced in 2.6:

Changed in version 2.6: This command does not delete the users associated with the current database.

Upvotes: 1

Zaur
Zaur

Reputation: 431

To delete all DBs use:

for i in $(mongo --quiet --host $HOSTNAME --eval "db.getMongo().getDBNames()" | tr "," " ");

do mongo $i --host $HOSTNAME --eval "db.dropDatabase()";

done

Upvotes: 2

Rimian
Rimian

Reputation: 38458

Also, from the command line:

mongo DATABASE_NAME --eval "db.dropDatabase();"

Upvotes: 131

DanH
DanH

Reputation: 5818

I followed the db.dropDatabase() route for a long time, however if you're trying to use this for wiping the database in between test cases you may eventually find problems with index constraints not being honored after the database drop. As a result, you'll either need to mess about with ensureIndexes, or a simpler route would be avoiding the dropDatabase alltogether and just removing from each collection in a loop such as:

db.getCollectionNames().forEach(
  function(collection_name) {
    db[collection_name].remove()
  }
);

In my case I was running this from the command-line using:

mongo [database] --eval "db.getCollectionNames().forEach(function(n){db[n].remove()});"

Upvotes: 47

Felipe Alarcon
Felipe Alarcon

Reputation: 956

For Meteor developers.

  1. Open a second terminal window while running your app in localhost:3000.

  2. In your project's folder run, meteor mongo.

    coolName = new Mongo.Collection('yourCollectionName');

  3. Then simply enter db.yourCollectionName.drop();

  4. You'll automatically see the changes in your local server.

For everybody else.

db.yourCollectionName.drop();

Upvotes: 2

Shalabh Raizada
Shalabh Raizada

Reputation: 364

Simplest way to delete a database say blog:

> use blog
switched to db blog
> db.dropDatabase();
{ "dropped" : "blog", "ok" : 1 }

Upvotes: 5

user2719890
user2719890

Reputation:

if you want to delete only a database and its sub-collections use this :

  • use <database name>;
  • db.dropDatabase();

if you want to delete all the databases in mongo then use this :

db.adminCommand("listDatabases").databases.forEach(function(d)
             {
              if(d.name!="admin" && d.name!="local" && d.name!="config")
                {
                 db.getSiblingDB(d.name).dropDatabase();
                }
             }
          );

Upvotes: 7

Gering
Gering

Reputation: 3490

I had the same problem, when I needed to reset all the collections but didn't want to loose any database users. Use the following line of code, if you would like to save the user configuration for the database:

use <whichever database>
db.getCollectionNames().forEach(function(c) { if (c.indexOf("system.") == -1) db[c].drop(); })

This code will go through all collection names from one database and drop those which do not start with "system.".

Upvotes: 87

Mohamed El Gamal
Mohamed El Gamal

Reputation: 91

Use 

[databaseName]
db.Drop+databaseName();

drop collection 

use databaseName 
db.collectionName.drop();

Upvotes: 9

Related Questions