Migrate mongodb database from localhost to remote servers

mongodb database-migration nosql
Praveen Singh Yadav picture Praveen Singh Yadav · Jan 23, 2014 · Viewed 53.3k times · Source

I created a database on my local ubuntu machine.

How can I transfer it to my remote server (ec2 Ubuntu)

Answer

Stennie picture Stennie · Jan 24, 2014

TL;DR

Use mongodump and mongorestore to take (and restore) a full binary backup of your MongoDB database. Compress the backup dump directory to make it faster to copy to your Amazon instance (BSON tends to compress very well).

Best practices

Rather than following adhoc instructions, I would strongly recommend reading the standard Backup and Restore with MongoDB Tools tutorial in the MongoDB manual.

You can also use a Filesystem snapshot, but mongodump and mongorestore only export the data so your backup will be smaller (i.e. your remote server will not inherit any excessive storage allocation due to preallocation).

Related questions

Connecting to MongoDB database on mLab fails authentication

I have a Parse app, and I'm trying to migrate my app's database to a MongoDB instance on mLab. I already have a fork of Parse Server set up on Heroku, and I'm using Heroku's mLab MongoDB add-on. I have …

Read More
Error while upgrading Mongodb from 3.2 to 3.6

I needed to upgrade mongodb from 3.2 to 3.6 in my environment. For the process i first migrated from 3.2 to 3.4 as recommended. After successful migration to 3.4, i started migration to 3.6 i am not able to start mongod. When checked log file i …

Read More
How to query MongoDB with "like"?

I want to query something with SQL's like query: SELECT * FROM users WHERE name LIKE '%m%' How to do I achieve the same in MongoDB? I can't find an operator for like in the documentation.

Read More