The fastest way to import CSV data into MySql database table via Command Line (LOAD DATA INFILE)

First of all, make sure your data is csv

[rusheilfrancis]

you know that one video you search the entire internet for, but nothing helps YOUR specific problem becuase you have no idea what youre doing BUT THEN you eventually find that sweet ecstasy of a command that runs doing what you want it to... this is that video for me. I am applying for a job i have no business applying to but if i manage to get their take home test done (by some miracle) hopefully i get a job. MUCH THANKS SIR, YOU ARE WONDERFUL

[hefjjkd]

Worked like a charm. Loaded a 28 GB (21 mm rows) database in 4.5 minutes versus running the import wizard from SQL workbench, which did inserts and ran for 2 days before I shut it down after loading just 2 mm rows. Did a TRUNC command to clear the DB but keep the schema. Had to "SET GLOBAL local_infile = true; " as someone else stated and then did the load command. Everything worked perfectly. Thanks.

[theresama]

You are absolutely amazing!!!
I could not get it to work using import table wizard. I spent almost 2 hours. With the help of your video, less than 10 MILLION THANKS!!

[ikyavenusg]

Exactly what I'm looking for and with a great detailing. Thanlks a lot man.

[BigDuzPimpin]

THANK GOD I clicked on video to READ rather than maybe a google search, and read countless forum OUSTANDING

[pszsosj]

Used the trick. Worked and saved 7 lives effort.

[lordisaac]

are all csv the same? I've been trying to just use a .txt file with tab separators and \n at the end of each line, but it's screwing up the formatting of the last column

[casst]

very helpful, i could not use the local infile feature, however, when i adjust just the load data infile, things worked fine..thanks kindly!

[sai_sh]

We have to create a table within database before this execution but what incase of those tables having many columns

[d.o.balogun]

I have a question.
If there were some records in the table before, are we still going to use the same command?

[harshkondkar]

My dataset has accents and this isn't working on that. Any suggestions?

[AnilKumarReddy-yqtx]

For this process do i need to create a table and define the column names ?

[marcosespinola]

After hours of resesech, finally can import the fucking csv to Workbench, thanks you!

[raziqnasrullah]

i can't say anything except thank you, this means a lot...❤❤

[chatpot]

Is there any other method to load big files? Because I am getting restriction error even after moving the file to the directory location. I have also tried changing directory location from configuration file, but nothing worked. Please help!

[sheetalkumari]

Its a magic working with these steps to load file

[harsha]

rejected due to restrictions on access. what to do now? where is this home page connection thing?

[manojvilasagaram]

ERROR 2 (HY000): File not found (Errcode: 2) How to solve this error??

[AnkurSharma]

Hi. My data has commas in between like in "address" column. So the data is getting misplaced in other columns. can you please show how to deal with that.
Thank you

[mrzatansafe]

how to import csv file to mysql remote server