I have a csv file that will be setup to be transferred to my server in a specified folder. I need a script that will take that file, add it to a mysql database and update the database accordingly. The data will not replace the existing data but add to it so it will be historical. The data is US stocks so each day will have certain data points relative to the each stock. The average file is about 3mb.
The updates will come once a day so this task will need to be setup via a cronjob that I can manage via cpanel.