Bulk impoprting CSV files

Is there a way to load several .csv files in batch on a Windows 10?

I have 58 csv files I want to load into a table.

8+GB of data.

What I concat them all together, it fails. It processes for about 20-30 seconds and then gives me the "An error occurred the application" window. (I sent the bug report and I have attached it)

You should prefer the "Server parses files contents" method, which is normally way faster and less memory consuming.

You may also compose the LOAD DATA commands yourself, but first retry the import dialog.

I tried "Server parses ...' but still didn't like it

This worked (and really fast):

LOAD DATA LOCAL INFILE '/path/to/your/csv/file/model.csv' INTO TABLE test.dummy FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';

Just a note to anyone who will be using the LOAD method:

In windows (not sure about linux) you will need to double the "\" slashes in the file PATH: \

The "Server parses..." method composes and fires such a LOAD DATA command. You probably had different control characters in the import dialog.