Data import problem

Denys_82412 · April 9, 2019, 8:26pm

I see it’s not only me how suffers from such an annoying thing and every time somebody should play around. So does the good solution or explanation in reality exist?

OK$ mongo mongodb+srv://m220student:m220password@mflix-zoed0.mongodb.net/test

BAD$ mongorestore --drop --gzip --uri “mongodb+srv://m220student:m220password@mflix-zoed0.mongodb.net/test” data

I’ve already received maybe all possible error messages with the last one “cannot unmarshal DNS message”

Norberto · April 9, 2019, 9:30pm

Hi @Denys_82412,

Try to import data to your Atlas free tier cluster by following the instructions on the Command Line Tools page for data import/restore

You will find clear instructions on how to import the dataset.

N.

Denys_82412 · April 9, 2019, 11:13pm

Hi, Norberto.

Yeap. It works. But the context is a bit different:

$ mongorestore --gzip --host mflix-shard-0/mflix-shard-00-00-racey.mongodb.net:27017,mflix-shard-00-01-racey.mongodb.net:27017,mflix-shard-00-02-racey.mongodb.net:27017 --ssl --username m220student --password m220password --authenticationDatabase admin data

VS

$ mongorestore --drop --gzip --uri “mongodb+srv://m220student:m220password@mflix-racey.mongodb.net/test” data

And who knows how many people gonna look again for such solution, firstly trying the different ways with README… What is not good at all.

An_De · April 12, 2019, 5:29am

If things don’t work from given documentation, why does such documentation exist, only to confuse beginners?

An_De · April 12, 2019, 5:41am

In Atlas after I click ‘Command Line Tools’. What should happen? I’ve clicked on it and nothing happens. Should a window pop-up? I’m using Google Chrome Browser. Thanks

Denys_82412 · April 12, 2019, 3:40pm

Hi @An_19003,
It should be a new page like this:

olami123 · April 14, 2019, 5:15am

Hi Norberto,

thanks for all the assistance so far! I was having the same issue as Denys, but I followed your instructions and the import worked, but the issue now is that only two sets of data where restored/imported. here is the screenshot :

what do you think the problem is?

josealonso2209 · April 14, 2019, 9:47pm

Could someone help me, to know what may be happening?
This is the first option.

and this is the second option.

I do not work in any way, I do not know what may be happening.

Denys_82412 · April 14, 2019, 11:21pm

Welcome @josealonso2209 to data import club,

Actually, with the first one, it could be anything. As MongoDB’s engineers over-engineered something. The former is not right because of missing data. If you don’t indicate some other folder it will be looking a folder ‘dump’. So finish your line with $ … data and it must work.

Regards,
D.

Ali_Shirazee_12248 · April 15, 2019, 6:52am

Is this documentation for real? I cant seem to import the data based on their guild-lines. mongoStore is returning command not found and so is mongo
any advice

Norberto · April 15, 2019, 1:13pm

Hi @olalekan_ogundipe_04604,

Can you share the command that you’ve executed ?

After you’ve connected to the cluster with your mongo shell or Compass you should be able to see the following collections in your mflix database:

MongoDB Enterprise Cluster0-shard-0:PRIMARY> use mflix
switched to db mflix
MongoDB Enterprise Cluster0-shard-0:PRIMARY> show collections
comments       →  19.808MB /  0.004MB
movies         →  61.846MB /  0.004MB
sessions       →   0.138MB /  0.004MB
theaters       →   0.334MB /  0.004MB
users          →   0.028MB /  0.004MB
watching_pings → 180.198MB / 56.023MB

Is that not the case ?

N.

Norberto · April 15, 2019, 1:18pm

Hi @Denys_82412,

Can you try again with the following format:

mongorestore --gzip --drop --uri "mongodb+srv://m220student:m220password@mflix-6y0lq.mongodb.net" data

The issue you are getting is related with the trailing connection options that mongorestore does not really like.

I agree, this should not be a friction point. Thanks for the feedback.

In any case, if you follow my instructions, and copy paste the mongorestore command from the Command Line Tools modal, this you will not get into this issue.

N.

Ali_Shirazee_12248 · April 15, 2019, 11:09pm

hey I am getting this message and nothing else

Ali_Shirazee_12248 · April 16, 2019, 12:15am

am i doing something wrong here? im following the read me and its not working? do you guys have a screen shot on the right way to import data, you must excuse me as I have just recently considered learning MongoDb havent looked at the alternatives.

Ali_Shirazee_12248 · April 16, 2019, 12:17am

the application seems to be running

Ali_Shirazee_12248 · April 16, 2019, 12:54am

its working now. thanks just needed some time

santiago_75841 · May 15, 2019, 6:22pm

I have the following problem

and I have no idea what causes it,
the documentation is a bit confusing to me
I have mongodb installed, I tried to make the connection and import the data but I could not see the application work normally … I do not know what to expect … the application runs and shows the loading spinner logo …and nothing else…Im stuck here…

kanikasingla · August 2, 2019, 7:01am

Hi @santiago_75841,

Thanks for the screenshot.

The error while running mongorestore command means you need to add “Mongo Bin path” to your environment variable.

26%20PM

Let me know how it goes!

Kanika

santiago_75841 · May 16, 2019, 1:17pm

thanks kanikasingla, it works

McFarJ · May 21, 2019, 1:43pm

Thanks, that worked for me (when replacing 6y01q wirth the corresponding code in my uri). That command wasn’t clear to me from the instructions in the course materials.

EDIT: perhaps I spoke too soon… when trying to start the MFlix application, this happens:

$ npm start
> server@1.0.0 start /home/jsiks/Sites/mflix-js
> nodemon -L ./index.js

[nodemon] 1.17.5
[nodemon] to restart at any time, enter `rs`
[nodemon] watching: *.*
[nodemon] starting `node ./index.js`
Error: querySrv ENOTFOUND _mongodb._tcp.uv61m.mongodb.net
    at QueryReqWrap.onresolve [as oncomplete] (dns.js:196:19)
[nodemon] app crashed - waiting for file changes before starting...