How to import csv file to mysql

[eluser]Jaketoolson[/eluser]
Just seems weird that you went from using a great convention for inserting CSV files into MySQL directly, to a process requiring PHP to open the CSV file and parse the contents line by line, performing an insert on each line! At least perform an extended insert if you're going to use this drawn out method. On a daily basis, using the code I pasted to you (which is the same method you used in your original inquiry), I am inserting 18-32MB csv files in a matter of seconds.