Hi, i have a script that runs once a month on my site which updates our database with GEO co-ordinates. This dump contains 100K rows of data.
This all worked fine on my development server, however i have just found out that my hosting company not support LOAD DATA INFILE on their cloud databases for security reasons.
Does anyone know if there is an alternative way to do this update as inserting the data normally, without LOAD DATA INFILE, takes about 5 minutes.
Thanks in advance for your help...