How do I refresh mysql queries every X-minutes.
Posted on 2009-04-21
I am using php to refresh oracle data to a mysql database, that part is fairly smooth. I need a way to run this code every 15 minutes. I do not have to have the refresh run on a website, and would prefer to do this through an application (ex. Java). Does anyone know the best way, or best programming language to do the following that could be automated?
Currently I query an Oracle database, send info to Mysql database (currently using php via an intranet website to send to txt file, then using DATA FILE INLOAD to write to mysql.