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.
41 freelancers are bidding on average $191 for this job
Hello, My name is Sergey. I am Freelancer from [url removed, login to view], Russia. I have checked "[url removed, login to view]" I can help you as PHP programmer to create script to run it everyday at 12:30 AM and import CSV files via FTP and Daha fazlası
Hi! I can create shell script that can be scheduled in cron. This shell script will execute mysql command like this LOAD DATA INFILE '[url removed, login to view]' INTO TABLE ... with some additional options (path to file, mysql con Daha fazlası
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....