export and import data from mongodb using node.js express

Question

I want to export all data from my server to my local(also i don't have a backup so this will serve as a backup. So I used the below code to get the collection in a json format and save to the local.

I am using mongodb and node express.

dbName.find().exec(function(err, output){

var jsonOutput=JSON.stringify(output)

fs.writeFile('downloads/output.json', output, function (err) {
        if (err) {
            console.log(err)
            res.send('error')
        }
        else{
            var filename = 'res.json'
            var mimetype = 'application/json'

            res.setHeader('Content-disposition', 'attachment; filename=' + filename)
            res.setHeader('Content-type', mimetype)
            res.end(jsonOutput)
        }
    })
})

This gives me what I want. Now I want to process the json in my local machine so that my local data is in sync with the server.

How to store all the data in bulk to the backend?
I have few references between the schema, so will new '_id' be created hence affecting my references
If you think this is not the right way to export the data, how can it be done using node express?

vmkcom · Accepted Answer · 2015-11-12 10:33:08Z

2

try to use mongodump or mongoexport. https://docs.mongodb.org/manual/core/backups/

mongoexport provide efficent way to export data from collection (by query if you want)

mongodump makes a full database dump (backup) so you can easily restore it anywhere, with the same ids, references, indexes. All your stuff

You can use node.js child_process.exec for running mongodump/mongoexport. You can use linux crontab for scheduling backups. So many ways to organize this with right tools

answered Nov 12, 2015 at 10:33

vmkcom

1,67812 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

prdtuty Over a year ago

I just tried to list all the collection names for testing using child_process exec. But I keep on getting stderr: getCollectionsNames is not recognized as an internal or external command.

vmkcom Over a year ago

you can run mongodb commands via mongodb-driver github.com/mongodb/node-mongodb-native

Collectives™ on Stack Overflow

export and import data from mongodb using node.js express

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related