How do I export/dump mongodb database?

Question

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

You should accept helpful answers, by the way. – Sergio Tulentsev Jun 14 '12 at 21:33 — Sergio Tulentsev, Jun 14 '12 at 21:33

score 41 · Answer 1 · edited Aug 24 '20 at 05:42

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

score 28 · Answer 2 · answered Jun 14 '12 at 21:30

28

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.

answered Jun 14 '12 at 21:30

Sergio Tulentsev

16

for the mongo clueless like me who came here, replace `local` with the name of the DB you want to export and leave off `--collection` if you want to export the whole db. – Jason Jan 24 '13 at 18:11