The LOAD DATA INFILE statement reads rows from a text file into a table at a very high speed. LOAD DATA INFILE is the complement of SELECT … INTO OUTFILE. To write data from a table to a file, use SELECT … INTO OUTFILE. To read the file back into a table, use LOAD DATA INFILE. The syntax of the FIELDS and LINES clauses is the same for both statements. Both clauses are optional, but FIELDS must precede LINES if both are specified.
For a sucessful operation, The fields count in the CSV file should match with the column count of the table. Otherwise your operation result will be Invalid/Erroneous. Also path to the CSV file should be correctly specified.
When opening a 100 MB plus single file within your favourite viewer, editor, 90-95% chance that Your computer would probably freeze. That will bring OS, You into a dead lock state which would never complete. If you want to go through your error logs, data dumps, or any other really big stuff like 1 GB plus files, You should require some tools that would carefully handle everything without any problem. These tools includes gVim, large-textfile-viewer etc. But these tools have some limitations like file size is restricted to 2 or 3 GB. But sometimes your error logs, data dumps or CSVs cross more than 5 GB! In this case You can try this below tool.
This tool will let you open really very very Huge, Giant, Big, Mammoth, Monster ((25 GB+ single file tested)) file on the fly. The main benefit of this tool is that you can open your huge files directly within your browser. You don’t need to download any desktop applications, mobile apps to view your big data. It will take very less memory so that the Programs/Process in the system won’t get affected. All the process happens just within your browser. The only thing you’ve to keep in mind that You need to have HTML5 enabled browser. That’s not at all a problem since all the latest browsers come with built in support for HTML5. Once again, The really cool feature is that you don’t need to download any external plugin, software or any other tool! Just browse your Giant file here & Click to open. That’s all. Enjoy Opening Huge files. Share it..:)