Create an mySQL query on Cpanel which will import data from .txt files stored on the Cpanel ftp once a day. I have attached samples of the .txt files. There are multiple files on the ftp, they are labelled with todays date in reverse order i.e. YY-MM-DD. The file contains time stamps and a count. The query needs to import the file with todays date, and separate the time stamp and count. The query must be automatically triggered to occur once a day, at 12:30am.
42 freelancers are bidding on average $188 for this job
Me and my team are working on the database projects.. have great experience in database. i can do this for you... this is to be done in 2 days.. contact me so that we can proceed further....