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 46 · Answer 1 · edited Aug 24 '20 at 05:42

46

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

edited Aug 24 '20 at 05:42

DevCo

answered Jun 25 '14 at 07:17

krishna

this comment is to help to others, from mongodb 4.4+ you need install mongodb-tools to get mongodump/mongorestore working. – Subramanya Rao Jun 14 '22 at 12:54

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

17

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