Export all MongoDB collections to JSON

mongoexport-all-collections-as-json.sh

#!/bin/bash

DB=$1
COLLECTIONS=$(mongo localhost:27017/$DB --quiet --eval "db.getCollectionNames()" | sed 's/,/ /g')

for collection in $COLLECTIONS; do
    echo "Exporting $DB/$collection ..."
    mongoexport -d newtickettoolDB -c $collection -o $collection.json
done

Small fix on this line: mongoexport -d newtickettoolDB -c $collection -o $collection.json needs to be mongoexport -d $DB -c $collection -o $collection.json

Thanks for the code btw :)

I had to use the code bellow to get the names of the collection properly
mongo localhost:27017/$DB --quiet --eval "db.getCollectionNames()" | tr -d '\[\]\"[:space:]' | tr ',' ' '

mongo localhost:27017/$DB --quiet --eval "db.getCollectionNames()"  | grep \" | tr -d '\[\]\"[:space:]' | tr ',' ' '  

I think this is a better solution, or you may get stuff like successfully connected to db as a collection

jq version

#!/bin/bash

DB=$1
COLLECTIONS=$(mongo localhost:27017/$DB --quiet --eval "db.getCollectionNames()" | jq '. | join(" ")')

for collection in $COLLECTIONS; do
    echo "Exporting $DB/$collection ..."
    mongoexport -d $DB -c $collection -o $collection.json
done

For me, the last version failed due to first/last extra quotes " in the collection list.

Fixed:

#!/bin/bash

DB=$1
COLLECTIONS=$(mongo localhost:27017/$DB --quiet --eval "db.getCollectionNames()" | jq -r '. | join(" ")')

for collection in $COLLECTIONS; do
    echo "Exporting $DB/$collection ..."
    mongoexport -d $DB -c $collection -o $collection.json
done

mongo localhost:27017/integradornfse --quiet --eval "db.getCollectionNames()"| sed 's/,/\n/g'