qbonep
asked on
How do I refresh mysql queries every X-minutes.
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
qbonep, my comment was a server-side solution that will run 24/7 and does not require running out of a web page. Did you not understand my suggestion, perhaps?
~A~
~A~
ASKER
ok. sorry it took so long to get back. So run the cron job using php.... I'll give that a try. Do you have any good links as an example?
Hi,
Please look at these:
http://www.sitepoint.com/article/introducing-cron/
http://www.developertutorials.com/blog/php/running-php-cron-jobs-regular-scheduled-tasks-in-php-172/
Hope this will help you
Regards
Please look at these:
http://www.sitepoint.com/article/introducing-cron/
http://www.developertutorials.com/blog/php/running-php-cron-jobs-regular-scheduled-tasks-in-php-172/
Hope this will help you
Regards
What shobinson sent you would be a great example. I would highly recommend the first link. It actually shows using a PHP script as the target of a scheduled task via the cron system.
~A~
~A~
ASKER