Delete everything in a MongoDB database

Question

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

User · Answer

use  lt dbname gt  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

User · Answer

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

User · Answer

List out all available dbs show dbs Choose the necessary db  use  Drop the database  db dropDatabase     Few additional commands List all collections available in a db show collections Remove a specification collection db collection drop     Hope that helps

User · Answer

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

User · Answer

In the mongo shell   use  database   db dropDatabase      And to remove the users   db dropAllUsers

User · Answer

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

User · Answer

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             Connect to you database  run the code     It cleans the database by dropping the user collections and emptying the system collections

User · Answer

In MongoDB 3 2 and newer  Mongo   getDBNames   in the mongo shell will output a list of database names in the server    gt  Mongo   getDBNames      local    test    test2    test3      gt  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   lt  0           Drop if database is not admin  config  or local     Mongo   getDB x  dropDatabase             Example run    gt  show dbs admin   0 000GB config  0 000GB local   0 000GB test    0 000GB test2   0 000GB test3   0 000GB   gt  Mongo   getDBNames   forEach function x          if    admin    config    local   indexOf x   lt  0            Mongo   getDB x  dropDatabase                     gt  show dbs admin   0 000GB config  0 000GB local   0 000GB

User · Answer

For Meteor developers   Open a second terminal window while running your app in localhost 3000   In your project s folder run  meteor mongo  coolName   new Mongo Collection  yourCollectionName     Then simply enter db yourCollectionName drop     You ll automatically see the changes in your local server    For everybody else  db yourCollectionName drop

User · Answer

if you want to delete only a database and its sub-collections use this     use  lt database name gt   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   amp  amp  d name   local   amp  amp  d name   config                                      db getSiblingDB d name  dropDatabase

User · Answer

db getCollectionNames   forEach c  gt db c  drop

User · Answer

Use    databaseName  db Drop databaseName     drop collection   use databaseName  db collectionName drop

User · Answer

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

User · Answer

Here are some useful delete operations for mongodb using mongo shell To delete particular document in collections  db mycollection remove   name  quot stack quot     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

User · Answer

Simplest way to delete a database say blog    gt  use blog switched to db blog  gt  db dropDatabase       dropped     blog    ok    1

User · Answer

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  lt whichever database gt  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

User · Answer

Also  from the command line   mongo DATABASE NAME --eval  db dropDatabase

[mongodb] Delete everything in a MongoDB database

Examples related to mongodb