9:20 for anyone using mysql cli instead of mysql workbench add the parameter --local-infile=1 instead. Also if you are on windows every \ in the path must be escaped (put double backslash \\)
Thank you very ... I am really very grateful... I got both errors...I did this... 1.Refresh my sql 2. Replace '\' with '\\' The comment section helped a lot...thank you so much guys !!!
Hi Michael! Thank you SO much for this detailed step-by-step video. I have a file that has around 30 columns, is there any other way to make columns in scehma table, apart from the method that you have showed in this video?
Hello, I wanted to ask that is it mandatory to create a table before running teh load data infile command? becuase, I have like many mnay columns in a file and cant create a table manually. plz help
Close the connection, and choose "Edit Connection" in the context-menu of the connection. Then, in the "Advanced" tab, put the parameter OPT_LOCAL_INFILE=1 in the "Others" input field. Then reconnect and try again. That should do the trick.
make sure there are no spaces in the entire string "OPT_LOCAL_INFILE=1". Had the same error message and it drove me almost crazy until i figured out that I had spaces between the equal sign and the 1
Saved me and I am greatful. Thank you. Could you make a video on Error Code: 2013. Lost connection to MySQL server during query? If so, that would be awesome ! ! ! \^o^/
THIS IS THE ONLY RESOURCE THAT SHOWED WHAT I NEEDED AFTER AN ENTIRE DAY OF TRYING. THANKS!!!!!!!!
Such a life saver man! After 2 dreadful hours - you helped me out. God bless you!
You are a life saver!
Struggled so much with the table import wizard, but this was so helpful!
Thank You!
Thank you! Ive been trying fix this problem all night and you fixed it in a few minutes!
So thankful I came across your excellent video after one day of endless dead ends. Thank you. Thank you. Thank you!!
Thank you so much for this amazing video. It was on point and resolved my headache finally!
Great video! I was having so much trouble with Load command and your video really cleared up the confusion!
A big shoutout for you man. You saved a lot of my time. I mean a lot. Thanks.
9:20 for anyone using mysql cli instead of mysql workbench add the parameter --local-infile=1 instead. Also if you are on windows every \ in the path must be escaped (put double backslash \\)
Thank you very ... I am really very grateful...
I got both errors...I did this...
1.Refresh my sql
2. Replace '\' with '\\'
The comment section helped a lot...thank you so much guys !!!
Great video Michael. This was exactly what i needed!
thanks you just save my life
Oh my god. I cant tell you how badly i wanted this.
Thank you soo much.
I was about to cry now.
really helpful! I could load csv from my desktop FINALLY.
Hi Michael! Thank you SO much for this detailed step-by-step video. I have a file that has around 30 columns, is there any other way to make columns in scehma table, apart from the method that you have showed in this video?
You can use the table import wizard which automatically creates a table for the file. It's slow though. But for creating the table it's usable.
After starting the import,you can cancel the import but the column names and table will remain and then we can use infile load
Thanks a lot. It saved a lot many hours indeed!
Amazing video bro. It just solved my headache
ME SALVASTE. NO SÉ INGLÉS PERO LO EPXLICASTE TAN FÁCIL QUE PUDE ENTENDERLO. SALUDOS DESDE PERÚ. LO MÁXIMO
thank you Michael, hugely helpful!!
Hi! while importing the file, in 1st step itself I'm getting an error: "list index out of range". Please help.
hey there! I have followed the exact same steps as you have told but I it is still throwing error 2068: restrictions
Thanks you so much!
when I do this, I get OS errno 2 - which says that MySQL cannot find such file or directory. How can i fix that?
Thank you Michael. I got 170654 rows returned in 5 seconds. However, I need to type path as \\ instead of \ for this to work.
True for Windows OS. You're welcome!
Great Video Thanks Gentleman
I will try this..hope this works
I have a csv with 400k rows and with this method it returns only 1 row. Any idea why?
It imports only the rows that generate no error. Perhaps you have duplicates, perhaps some data type issues.
Hello, I wanted to ask that is it mandatory to create a table before running teh load data infile command? becuase, I have like many mnay columns in a file and cant create a table manually. plz help
what to do if we have date or string datatype in a column of table to be imported?
You can do type conversion with the LOAD command.
IN MY CASE IT GIVES ME AN ERROR 2068 load data local infile file request rejected due on access, some tip?
Close the connection, and choose "Edit Connection" in the context-menu of the connection. Then, in the "Advanced" tab, put the parameter OPT_LOCAL_INFILE=1 in the "Others" input field. Then reconnect and try again. That should do the trick.
make sure there are no spaces in the entire string "OPT_LOCAL_INFILE=1". Had the same error message and it drove me almost crazy until i figured out that I had spaces between the equal sign and the 1
When i run load data local infile....it shows an error: file not found.... can somebody tell me what is wrong
You need to specify the correct pathname.
Also, in Windows, use \\ instead of \
You're a life saver!!.. I've been on this for the past 20 minutes and all i had to do was use \\ instead of \..Thank you!
@@michaelkaufmann1978
Hi Michael. I'm getting this error -
Error Code 2068 : Request rejected due to restrictions on access. Please help how to sort it out.
Thank you.
if you have added the OPT_local_infinite = 1, try to restart your SQL. i met the same error and after restart it works.
@@xuancarlos8684 Thank you. It is working now. Thanks a lot :)
Saved me and I am greatful. Thank you. Could you make a video on Error Code: 2013. Lost connection to MySQL server during query? If so, that would be awesome ! ! ! \^o^/