I have a 500MB csv file that needs to be imported into my mysql database.
I've written a PHP script where I can upload the csv file to and it analyses the fields and does the actual importing. but it can only handle small files of max. 5MB. So that's a 100 files and actually pretty slow(uploading)
Is there another way? I have to repeat this process every month because the data in the file changes every month it's about 12 000 000 lines.