MYSQL Tutorial: Efficiently Importing Large CSV Files into MySQL Database with LOAD DATA INFILE

MYSQL server Setup

[AnalyticsExplorers]

Explore more on MYSQL CSV import:

[veqlrhr]

I was having a hard time finding the Program Data folder on my local disk, so for others who might be having the same issue here's a solution on Windows that worked for me: Click your disk, click the 3 dots next to view, click options, click view, and then click Show hidden files, folders, and drives. After I did that, the Program Data folder showed up!

[samratkundu]

Finally! A detailed video for this process.
Thank you so much 🙏

[Emotion-odob]

Omg thank you so much have seen many vedios but nothing workes.
U just saved me thank you thank

[mayadisilalahixipmia-]

but how to limit the number of rows i'm want to import?
(in this case, i jusr want to import the first 1000 lines)

[sarahqmangrum]

Steps on importing the .csv file from a Mac. I am having trouble locating the same pathways on my Mac. I understand that Macintosh HD is equivalent to C Drive on Windows PC but unable to locate next steps. This has been a great video up to this point as I was struggling to import a very large Excel file.

[maryadebimpe]

Thank you so much. I have watched a lot of videos, but after watching this video, I finally got it 😊. A new subscriber 🥳🥳

[sergiotorres]

Buddy, thank u so much for this video. I got a problem trying to resolve the secure-fiele-priv issue, but I read your comments and I could resolve it. THANKS A LOT.

[suvarna]

Everything went well until the last step. While trying to execute load data I file step, getting error code 1290. Can anyone please help me with it.

[opeyemi]

Thank you for the video. But, I couldn't find "DATA" inside the mysql server. All I have are bin, docs, etc, include, lib, share … please how can I fix this?

[bhavya.]

I am getting an Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement.

pls help

[louisocarroll]

What if mysql server is not on local computer? I keep getting the error: "Access denied for user..."

[indykoncepts]

Thank you for this. This is helpful.

However, I have been having error 1050. Table hotel_bookings already exists

[MDCRITICA]

2 IMPORTANT ISSUES:

1) You start showing that your CSV is already loaded in Excel, but what if it is in a different format? How to save it as a CSV making sure that data is changed properly?

2) What if I can't open the CSV cause it is heavy? How to load and change the DATE FORMAT without using excel

[Learn_lane]

Thank you for this video but I am getting this error when I am saving that file in mysql data folder " you don't have permission to save in this location contact the administrator to obtain permission" How to resolve this issue

[frederickjabagat]

Error Code: 1292. Incorrect date value: '2020' for column 'date_added' at row 1 I still keep getting this error even thought I updated my data dates from yyyy-mm-dd

[zainabjubril]

You lost me at the part where you 'pasted' on the file path. What did you paste because I didn't see you copy anything prior to that?

[martins__]

Great video! Was struggling with a dataset

[ND-lfrg]

HELLO i HAVE TRIED YOUR STEP BUT THEY ARE GIVING ME THIS ERROR: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

[asuquobassey]

Still having issues. My dataset does has lot of null values and its not a calculated field you can easily apply formula. How do I import this file with the nulls