How to export from xls with 1M rows to mysql?

Question

MySQL

I am using mysql 5.7, excel 2016 and mysql for excel utility.
Without problems I export 50k lines.
At 1M rows, the memory consumption of the excel.exe process steadily rises to 1.35 GB. Also the error
Exception message takes off:
The exception of type "System.OutOfMemoryException" is thrown.
Exception thrown by:
MySqlDataTable.AddExcelData
Stack trace:
in Microsoft.Office.Interop.Excel.Range.get_Count()
in MySQL.ForExcel.Classes.ExcelUtilities.GetRowValuesAsLinearArray(Range range, Int32 rowIndex, Boolean useFormattedValues)
in MySQL.ForExcel.Classes .MySqlDataTable.AddExcelData(TempRange temporaryRange)
The export script is generated on a Windows machine (more than 2 GB of free memory remains), Mayesquel on Linux (more than 3 GB of free memory).
Tried csv import in phpmyadmin , best result 30k rows .
I went through the settings of the mysql configs, increased all the limits.
How to accomplish this task?

Answer 1

Convert to CSV
And do a native file import