dbarasuk - 9:43 am on Aug 7, 2012 (gmt 0)
Can someone give an idea of this? I have a script intended to run every day at 18:30 local time that takes data from a mysql table and inserts it in an another table but on an oracle server. The test has been conducted locally on the two database with success and i run it at command line like this: php /path/to/php/file
How can i make it run automatically every day at 18h:30 local time (please i'd appreciate if you could write here a working code). Also another issue i've not tested yet is the timeout issue. If for instance the data is too large to be retreived from mysql and inserted in oracle on the other side within 60 seconds, is the entire dataset going to be inserted in the oracle table?
Thanks for your kind and prompt reply