best way to import 500MB csv file into mysql database?
- by mars
I have a 500MB csv file that needs to be imported into my mysql database.
I've made a php file where i can upload the csv file and it analyses the fields n stuff and does the actual importing. but it can only handle small fiels 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 :D