mongo-command-mongolab.txt

Import / Export Helper

MongoDB provides two mechanisms for importing and exporting data. One way is via the mongoimport and mongoexport utilities. These allow you to import and export JSON and CSV representations of your data. The other way is with mongorestore and mongodump utilities which deal with binary dumps.

In this tab we provide pre-filled strings for the commands that we find most useful.

Copy and paste from below to import or export from this database. For a full list of options 
that can be used with these commands, please see MongoDB's documentation on this subject.

Binary
Import database
	mongorestore -h ds031613.mongolab.com:31613 -d inventory -u <user> -p <password> <input db directory>
Export database
	mongodump -h ds031613.mongolab.com:31613 -d inventory -u <user> -p <password> -o <output directory>
Import collection
	mongorestore -h ds031613.mongolab.com:31613 -d inventory -u <user> -p <password> <input .bson file>
Export collection
	mongodump -h ds031613.mongolab.com:31613 -d inventory -c <collection> -u <user> -p <password> -o <output directory>


JSON
Import collection
	mongoimport -h ds031613.mongolab.com:31613 -d inventory -c <collection> -u <user> -p <password> --file <input file>
Export collection
	mongoexport -h ds031613.mongolab.com:31613 -d inventory -c <collection> -u <user> -p <password> -o <output file>

	
CSV
Import collection
	mongoimport -h ds031613.mongolab.com:31613 -d inventory -c <collection> -u <user> -p <password> --file <input .csv file> --type csv --headerline
Export collection
	mongoexport -h ds031613.mongolab.com:31613 -d inventory -c <collection> -u <user> -p <password> -o <output .csv file> --csv -f <comma-separated list of field names>

By Amran