CODEWITHSUNDEEP
mongodbimport
user1052073
user1052073

Reputation: 521

How do I export/dump mongodb database?

I tried a mongo export like this:

./mongodump --db local --collection lecturer

and then I tried:

./mongodump --db  local --collection posts --out - >  lecturer .csv

and I get the same error message: Syntax Error: syntax error (shell):1

  1. What's wrong with my code?
  2. Where is the data stored if export successfully?

Upvotes: 25

Views: 39706

Answers (2)

krishna
krishna

Reputation: 779

How to backup and restore databases

Start Mongo, open a new tab in terminal. First navigate to the folder where you want to save the backup, then type the following command.

Backup single database:

mongodump --host localhost --port 27017 --db db_name

Restore single database:

mongorestore --host localhost --port 27017 --db **** dump/db_name

(In this case, **** represents UserDefinedName for the database > mydb dump/db_name > this will import dump db into mydb)

Backup all databases:

mongodump --host localhost --port 27017

Restore all databases:

mongorestore --host localhost --port 27017  dump

Upvotes: 48

Sergio Tulentsev
Sergio Tulentsev

Reputation: 230336

mongodump is a command-line utility and it's supposed to be run from the system command prompt, not the mongo javascript shell.

./mongodump --db local --collection lecturer

if successful, this command will create some files under dump directory in the current dir.

Upvotes: 28

Related Questions