Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am newbie to the Mongo.Before this I have worked only with MySQL.In MySQL we can import and export database easily.I want to know is there any option available in Mongo to import and export database easily.Any help and suggestions will be highly appreciable.

share|improve this question
add comment

2 Answers 2

If you look inside mongodb/bin folder (ls -l) You can find a couple of binaries.

The mongoDB has import and export tools.

If you're running mongod locally on the default port, you can just do:

$ ./mongodump

Example: Dumping Everything

$ ./mongodump --host prod.example.com

Example: Dumping a Single Collection

$ ./mongodump --db blog --collection posts

Others like

mongoexport, mongoimport, mongorestore, bsondump etc.

for more http://www.mongodb.org/display/DOCS/Import+Export+Tools

share|improve this answer
add comment

You can use something like this to export:

mongodump -h yourhost -d yourdbname

And to import, just run:

mongorestore

It is important to remember that mongorestore just insert new documents, but does not update or delete the old ones. If you want to discard your database, you need to use the --drop:

mongorestore --drop

This is how I export and import databases like MySQL.

You can learn more about mongodump and mongorestore here:

mongodump documentation

mongorestore documentation

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.