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

Used the trick. Worked and saved 7 lives effort.

Its a magic working with these steps to load file

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

Amazing explanation.....it's working.....thank you so much

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

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

Thanks a ton bro 💯

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!

C:\Users\Nithesh Shetty>mysql -u Nithesh Shetty -p --local_infile
'mysql' is not recognized as an internal or external command,
operable program or batch file. I got this when tried to login

GOD BLESS YOU!

Thank you very much!

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

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.

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

Finally! I was about to go crazy since yesterday. Tried many methods. Writing scripts gave error each time. workbench is a total hell as you said! :)) Thanks a lot! Finally I can use my favorite SQL server without any problem. 🤩

how to import csv file to mysql remote server

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

Charley, you do all! Herhhh

THANK YOU!!!!

ERROR 2 (HY000): File 'C:/Users/villa/Data/dealers.csv' not found (Errcode: 2) How to solve this error??