I've been trying to load a table from a 450MB .csv file but keep getting syntax errors. The insert sql looks like this:
LOAD DATA LOCAL INFILE '/home/larry/web/test/public_html/dbip-city-lite-2020-04.csv' INTO TABLE IP_LOOKUP FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';
The code was copied from [https://www.mysqltutorial.org/import-csv-file-mysql-table/]
Does anyone see where I've gone wrong?
Additional question: How to accomplish this import on my web host?
Thanks in advance,
Larry