How to export all collections in MongoDB

Question

I want to export all collections in MongoDB by the command     mongoexport -d dbname -o Mongo json   The result is  No collection specified     The manual says  if you don t specify a collection  all collections will be exported  However  why doesn t this work   http   docs mongodb org manual reference mongoexport  cmdoption-mongoexport--collection  My MongoDB version is 2 0 6

User · Answer

Follow the steps below to create a mongodump from the server and import it another server local machine which has a username and a password  1  mongodump -d dbname -o dumpname -u username -p password 2  scp -r user remote   location of dumpname    3  mongorestore -d dbname dumpname dbname  -u username -p password

User · Answer

Exporting all collections using mongodump use the following command   mongodump -d database name -o directory to store dumps  To restore use this command  mongorestore -d database name directory backup where mongodb tobe restored

User · Answer

Please let us know where you have installed your Mongo DB    either in Ubuntu or in Windows    For Windows      Before exporting you must connect to your Mongo DB in cmd prompt and make sure that you are able to connect to your local host    Now open a new cmd prompt and execute the below command      mongodump --db database name --out path to save eg  mongodump --db mydb --out c  TEMP op json    Visit https   www youtube com watch v hOCp3Jv6yKo for more details     For Ubuntu     Login to your terminal where Mongo DB is installed and make sure you are able to connect to your Mongo DB    Now open a new terminal and execute the below command      mongodump -d database name -o file name to save eg  mongodump -d mydb -o output json     Visit https   www youtube com watch v 5Fwd2ZB86gg for more details

User · Answer

First  of Start the Mongo DB - for that go to the path as -    C  Program Files MongoDB Server 3 2 bin and click on the mongod exe file to start MongoDB server   Command in Windows to Export   Command to export MongoDB database in Windows from  remote-server  to the local machine in directory C  Users Desktop temp-folder from the remote server with the internal IP address and port     C   mongodump --host remote ip address 27017 --db  -o C  Users Desktop temp-folder  Command in Windows to Import   Command to import MongoDB database in Windows to  remote-server  from local machine directory  C  Users Desktop temp-folder db-dir   C   mongorestore --host ip --port 27017 -d  C  Users Desktop temp-folder db-dir

User · Answer

I wrote bash script for that  Just run it with 2 parameters  database name  dir to store files       bin bash  if      1    then         echo   Example of use   0 database name  dir to store           exit 1 fi db  1 out dir  2 if      out dir    then         out dir      else         mkdir -p  out dir fi  tmp file  fadlfhsdofheinwvw js  echo  print        db getCollectionNames      gt   tmp file cols  mongo  db  tmp file   grep       awk   print  2     tr          for c in  cols do     mongoexport -d  db -c  c -o   out dir exp   db    c  json  done rm  tmp file

User · Answer

If you want to dump all collections in all databases  which is an expansive interpretation of the original questioner s intent  then use  mongodump   All the databases and collections will be created in a directory called  dump  in the  current  location

User · Answer

For lazy people  use mongodump  it s faster   mongodump -d  lt database name gt  -o  lt directory backup gt    And to  restore import  it  from directory backup dump     mongorestore -d  lt database name gt   lt directory backup gt    This way  you don t need to deal with all collections individually  Just specify the database   Note that I would recommend against using mongodump mongorestore for big data storages  It is very slow and once you get past 10 20GB of data it can take hours to restore

User · Answer

Here s what worked for me when restoring an exported database   mongorestore -d 0   0 --drop  where   contained the exported bson files  Note that the --drop will overwrite existing data

User · Answer

If you want  you can export all collections to csv without specifying --fields  will export all fields    From http   drzon net export-mongodb-collections-to-csv-without-specifying-fields  run this bash script  OIFS  IFS  IFS         fill in your details here dbname DBNAME user USERNAME pass PASSWORD host HOSTNAME PORT    first get all collections in the database collections  mongo   host  dbname  -u  user -p  pass --eval  rs slaveOk   db getCollectionNames       collections  mongo  dbname --eval  rs slaveOk   db getCollectionNames       collectionArray   collections      for each collection for   i 0  i lt    collectionArray        i    do     echo  exporting collection    collectionArray  i         get comma separated list of keys  do this by peeking into the first document in the collection and get his set of keys     keys  mongo   host  dbname  -u  user -p  pass --eval  rs slaveOk   var keys       for var key in db   collectionArray  i   find   sort   id  -1   limit 1  0     keys push key      keys   --quiet         now use mongoexport with the set of keys to export the collection to csv     mongoexport --host  host -u  user -p  pass -d  dbname -c   collectionArray  i   --fields   keys  --csv --out  dbname   collectionArray  i   csv  done  IFS  OIFS

User · Answer

For dump  your DB fallow the below CMD     mongodump -d  lt your d name gt  -o  lt dump path gt  Ex mongodump -d qualetics -o D  dbpackup qualetics

User · Answer

mongodump using sh script     bin bash TIMESTAMP  date   F- H M  APP NAME  folder name  BACKUPS DIR   xxxx tst file bcup  APP NAME  BACKUP NAME   APP NAME- TIMESTAMP   usr bin mongodump -h 127 0 0 1 -d  lt dbname gt  -o  BACKUPS DIR  APP NAME  BACKUP NAME tar -zcvf  BACKUPS DIR  BACKUP NAME tgz  BACKUPS DIR  APP NAME  BACKUP NAME rm -rf  home wowza analytics bcup wowza analytics wowza analytics     7 days old backup delete automaticaly using given command  find  home wowza analytics bcup wowza analytics  -mindepth 1 -mtime  7 -delete

User · Answer

Open the Connection Start the server open new Command prompt   Export   mongo bin gt  mongoexport -d webmitta -c domain -o domain-k json  Import   mongoimport -d dbname -c newCollecionname --file domain-k json  Where   webmitta db name  domain Collection Name  domain-k json output file name

User · Answer

I dump all collection on robo3t  I run the command below on vagrant homestead  It s work for me  mongodump --host localhost --port 27017 --db db name --out db path

User · Answer

if you want to use mongoexport and mongoimport to export import each collection from database  I think this utility can be helpful for you  I ve used similar utility couple of times   LOADING false  usage         cat  lt  lt  EOF     usage   0  options  dbname      OPTIONS          -h      Show this help          -l      Load instead of export         -u      Mongo username         -p      Mongo password         -H      Mongo host string  ex  localhost 27017  EOF    while getopts  hlu p H   opt  do     MAXOPTIND  OPTIND      case  opt in          h              usage             exit                        l              LOADING true                        u              USERNAME   OPTARG                         p               PASSWORD   OPTARG                         H              HOST   OPTARG                                         echo  Invalid option  opt              exit 1                    esac done  shift     MAXOPTIND-1    if   -z   1     then     echo  Usage  export-mongo  opts   lt dbname gt       exit 1 fi  DB   1  if   -z   HOST     then     CONN  localhost 27017  DB  else     CONN   HOST  DB  fi  ARGS    if   -n   USERNAME     then     ARGS  -u  USERNAME  fi if   -n   PASSWORD     then     ARGS   ARGS -p  PASSWORD  fi  echo                              Mongo Export                           echo       Host        HOST  echo       Database    DB  echo       Username    USERNAME  echo       Password    PASSWORD  echo       Loading     LOADING  echo                                                                      if  LOADING   then     echo  Loading into  CONN      tar -xzf  DB tar gz     pushd  DB  gt  dev null      for path in   json  do         collection   path  json          echo  Loading into  DB  collection from  path          mongoimport  ARGS -d  DB -c  collection  path     done      popd  gt  dev null     rm -rf  DB else     DATABASE COLLECTIONS   mongo  CONN  ARGS --quiet --eval  db getCollectionNames      sed  s     g        mkdir  tmp  DB     pushd  tmp  DB 2 gt  dev null      for collection in  DATABASE COLLECTIONS  do         mongoexport --host  HOST -u  USERNAME -p  PASSWORD -db  DB -c  collection --jsonArray -o  collection json  gt  dev null     done      pushd  tmp 2 gt  dev null     tar -czf   DB tar gz   DB 2 gt  dev null     popd 2 gt  dev null     popd 2 gt  dev null     mv  tmp  DB tar gz    2 gt  dev null     rm -rf  tmp  DB 2 gt  dev null fi

User · Answer

If you are OK with the bson format  then you can use the mongodump utility with the same -d flag  It will dump all the collections to the dump directory  the default  can be changed via the -o option  in the bson format  You can then import these files using the mongorestore utility

User · Answer

you can create zip file by using following command  It will create zip file of database  dbname  provided You can later import the following zip file in you mongo DB    Window filepath C  Users Username mongo   mongodump --archive  filepath    filename  gz --gzip --db  dbname

User · Answer

I needed the Windows batch script version  This thread was useful  so I thought I d contribute my answer to it too   mongo   YOUR SERVER   YOUR DATABASE   --eval  rs slaveOk   db getCollectionNames    --quiet gt   collections txt for  f   a in   type   collections txt   do  set COLLECTIONS   a for   a in   COLLECTIONS   do mongoexport --host  YOUR SERVER  --db  YOUR DATABASE  --collection   a --out data   a json del   collections txt   I had some issues using set  p COLLECTIONS  lt   collections txt  hence the convoluted for  f method

User · Answer

I realize that this is quite an old question and that mongodump mongorestore is clearly the right way if you want a 100  faithful result  including indexes   However  I needed a quick and dirty solution that would likely be forwards and backwards compatible between old and new versions of MongoDB  provided there s nothing especially wacky going on  And for that I wanted the answer to the original question   There are other acceptable solutions above  but this Unix pipeline is relatively short and sweet   mongo --quiet mydatabase --eval  db getCollectionNames   join   n        grep -v system indexes     xargs -L 1 -I    mongoexport -d mydatabase -c    --out    json   This produces an appropriately named  json file for each collection    Note that the database name   mydatabase   appears twice  I m assuming the database is local and you don t need to pass credentials but it s easy to do that with both mongo and mongoexport   Note that I m using grep -v to discard system indexes  because I don t want an older version of MongoDB to try to interpret a system collection from a newer one  Instead I m allowing my application to make its usual ensureIndex calls to recreate the indexes

User · Answer

You can do it using the mongodump command  Step 1   Open command prompt Step 2   go to bin folder of your mongoDB installation  C  Program Files MongoDB Server 4 0 bin  Step 3   then execute the following command mongodump -d your db name -o destination path your db name   test destination path   C  Users HP Desktop  Exported files will be created in destination path your db name folder  in this example C  Users HP Desktop test  References   o7planning

User · Answer

You can use mongo --eval  printjson db getCollectionNames     to get the list of collections and then do a mongoexport on all of them   Here is an example in ruby     out    mongo    DB HOST    DB NAME  --eval  printjson db getCollectionNames         collections   out scan           map    s  s gsub               collections each do  collection      system  mongoexport --db   DB NAME   --collection   collection   --host    DB HOST   --out   collection  dump    end

User · Answer

I found after trying lots of convoluted examples that very simple approach worked for me   I just wanted to take a dump of a db from local and import it on a remote instance   on the local machine   mongodump -d databasename   then I scp d my dump to my server machine   scp -r dump user xx xxx xxx xxx     then from the parent dir of the dump simply   mongorestore    and that imported the database   assuming mongodb service is running of course

User · Answer

Even in mongo version 4 there is no way to export all collections at once  Export the specified collection to the specified output file from a local MongoDB instance running on port 27017 you can do with the following command    mongoexport exe  --db xstaging --collection products --out c  xstaging products json

User · Answer

In case you want to connect a remote mongoDB server like mongolab com  you should pass connection credentials eg   mongoexport -h id mongolab com 60599 -u username -p password -d mydb -c mycollection -o mybackup json

User · Answer

There are multiple options depending on what you want to do  1  If you want to export your database to another mongo database  you should use mongodump   This creates a folder of BSON files which have metadata that JSON wouldn t have   mongodump mongorestore --host mongodb1 example net --port 37017 dump    2  If you want to export your database into JSON you can use mongoexport except you have to do it one collection at a time  this is by design    However I think it s easiest to export the entire database with mongodump and then convert to JSON     -d is a valid option for both mongorestore and mongodump  mongodump -d  lt DATABASE NAME gt  for file in dump     bson  do bsondump  file  gt   file json  done

User · Answer

If you re dealing with remote databases you can try these commands given that you don t mind the output being BSON 1  Dump out as a gzip archive mongodump --uri  quot mongodb   YOUR USER ID YOUR PASSWORD YOUR HOST IP YOUR DB NAME quot  --gzip --archive  gt  YOUR FILE NAME  2  Restore  Copy a database from one to another  mongorestore --uri  quot mongodb    targetUser  targetPwd  targetHost  targetDb quot  --nsFrom  quot  sourceDb   quot  --nsTo  quot  targetDb   quot  --gzip --archive

User · Answer

If you have this issue  Failed  can t create session  could not connect to server  connection     auth error  sasl conversation error  unable to authenticate using mechanism  quot SCRAM-SHA-1 quot    AuthenticationFailed  Authentication failed  then add --authenticationDatabase admin eg  mongodump -h 192 168 20 30 27018 --authenticationDatabase admin -u dbAdmin -p dbPassword -d dbName -o path to folder

User · Answer

If you want to backup all the dbs on the server  without having the worry about that the dbs are called  use the following shell script      bin sh  md  which mongodump  pidof  which pidof  mdi   pidof mongod  dir   var backup mongo   if     -z   mdi       then         if     -d   dir               then                mkdir -p  dir            fi          md --out  dir  gt  dev null 2 gt  amp 1    fi   This uses the mongodump utility  which will backup all DBs if none is specified   You can put this in your cronjob  and it will only run if the mongod process is running  It will also create the backup directory if none exists   Each DB backup is written to an individual directory  so you can restore individual DBs from the global dump

User · Answer

Previous answers explained it well  I am adding my answer to help in case you are dealing with a remote password protected database  mongodump --host xx xxx xx xx --port 27017 --db your db name --username your user name --password your password --out  target folder path

[mongodb] How to export all collections in MongoDB?

Examples related to mongodb

Examples related to export