How to export remote mongodb database with mongodump on MacOS
In this article we will see how to export remote mongodb database from command line on Mac.
MongoDB is a cross-platform database that can be used in any operating system. It is written in C++ and has a document-oriented data model. Its storage engine supports dynamic schema, indexing, and real-time queries.
MongoDB databases are stored on the filesystem of the server machine. One way to back up these databases is by using mongodump — a command line utility for backing up MongoDB databases to files on disk.
1- Install mongodump
mongodump comes with Mongo database installation, so to get it, you can use the following command:
$brew tap mongodb/brew; brew install mongodb-community
It’s highly recommended to install brew on your mac, and you can do it by using the following command from Homebrew website.
$/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"
Then you can simply execute this command to export your database:
$mongodump --host MONGODB_HOST -d MONGODB_DB_NAME --port MONGODB_PORT --authenticationDatabase=admin --username MONGODB_USERNAME --password MONGODB_PASSWORD --out /path/to/your/local/export
Note that the — authenticationDatabase=admin can be optionnal
Example:
$mongodump --host db.example.com -d my database --port 27017 --authenticationDatabase=admin --username root --password dbpassword --out /Users/user/Documents/exportdb
All the database collections should be exported under the target — out folder.
That’s all; I hope this may help you ;)