How do I drop a MongoDB database from the command line

Question

What s the easiest way to do this from my bash prompt

User · Answer

I found this easy to remember   mongo   to start the mongodb shell  show dbs   to list existing databases  use  lt dbname gt    the  lt dbname gt  is the database you d like to drop  db   should show  lt dbname gt  just to be sure I m working with the right database  db dropDatabase     will delete the database  amp  return    dropped      lt dbname gt     ok    1

User · Answer

use following command from mongo shell to drop db     use      db dropDatabase

User · Answer

Like this   mongo  lt dbname gt  --eval  db dropDatabase      More info on scripting the shell from the command line here  https   docs mongodb com manual tutorial write-scripts-for-the-mongo-shell  scripting

User · Answer

You could also use a  heredoc    mongo localhost db  lt  lt EOF db dropDatabase   EOF   Results in output like   mongo localhost db  lt  lt EOF db dropDatabase   EOF MongoDB shell version  2 2 2 connecting to  localhost db    dropped     db    ok    1       bye   I like to use heredocs for things like this  in case you want more complex sequence of commands

User · Answer

In you command prompt  First connect to mongodb using following command   mongo -h  host-name   port number  -d  dbname  -u  username  -p  password    you will be accessing db with  lt dbname gt    Run the following command to drop the whole database   db dropDatabase

User · Answer

one liner remote remove all collections from mongo database  note must use --host   -h is help for mongo command   and -d is not an option  select the db and command after password   mongo --host  lt mongo host gt   lt mongo port gt  -u  lt db user gt  -p  lt db pass gt   lt your db gt  --eval  db dropDatabase

User · Answer

Other way   echo  db dropDatabase      mongo  lt database name gt

User · Answer

Drop a MongoDB database using python   import argparse  import pymongo   if   name         main                 Drop a Database               parser   argparse ArgumentParser       parser add argument  --host   default  mongodb   localhost 27017                           help  mongodb URI  default    default s        parser add argument  --database   default None                          help  database name    default s         args   parser parse args        client   pymongo MongoClient host args host       if args database in client list database names            client drop database args database          print f Dropped    args database         else          print f Database   args database   does not exist

User · Answer

Surprised that we haven t seen this variation come up   This minimizes extra args on the command line and explicitly shows the DB being switched to FOO and then dropped    mongo --host  quot mongodb   machine port quot  --eval  db getSiblingDB  quot FOO quot   dropDatabase

User · Answer

LogIn into your mongoDB command line  And type the below commands  use  YOUR DATABASE NAME   db dropDatabase

User · Answer

Execute in a terminal   mongo    To go to shell  show databases    To show all existing databases   use  lt DATA BASE gt     To switch to the wanted database   db dropDatabase      To remove the current database

User · Answer

db will show the current Database name type  db dropDatabase     1- select the database to drop by using  use  keyword   2- then type db dropDatabase

User · Answer

Open a terminal and type  mongo   The below command should show the listed databases  show dbs      the  lt dbname gt  is the database you d like to drop    use  lt dbname gt       the below command will delete the database    db dropDatabase      The below should be the output in the terminal       quot dropped quot    quot  lt dbname gt  quot      quot ok quot   1

User · Answer

Here are some use full 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 collection    db mycollection drop    to delete database   first go to that database by use mydb command and then   db dropDatabase     directly from command prompt or blash   mongo mydb --eval  db dropDatabase

User · Answer

Open another terminal window and execute the following commands    mongodb use mydb db dropDatabase     Output of that operation shall look like the following  MAC FOLDER USER  mongodb  gt  show databases local      0 78125GB mydb       0 23012GB test       0 23012GB  gt  use mydb switched to db mydb  gt db dropDatabase      dropped     mydb    ok    1    gt    Please note that mydb is still in use  hence inserting any input at that time will initialize the database again

User · Answer

Using Javascript  you can easily create a drop bad js script to drop your database   create drop bad js   use bad  db dropDatabase      Than run 1 command in terminal to exectue the script using mongo shell   mongo  lt  drop bad js

User · Answer

You don t need heredocs or eval  mongo itself can act as an interpreter       usr bin env mongo var db   new Mongo   getDB  someDatabase    db dropDatabase      Make the file executable and run it

User · Answer

The best way to do it is from the mongodb console     gt  use mydb    gt  db dropDatabase      Alternatively  you can stop mongod and delete the data files from your data directory  then restart   Hint  you can also move the data files to a subfolder  and delete them if you re sure you no longer need them

User · Answer

Start MongoDB  Command for Database drop is    1  first select the database which you want to delete  use  lt  database name  gt    2  Then use this    db dropDatabase

User · Answer

Eventhough there are several methods  The best way  most efficient and easiest  is using db dropDatabase

[mongodb] How do I drop a MongoDB database from the command line?

Examples related to mongodb