Re: PHP / MySQL automatic import

[Andrey Hristov]

If you have cron then you don't need PHP considering that you can run mysqlimport.
See http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html .
Just put mysqlimport as command to be run every 15 minutes. If this solution is not feasible that write a PHP script that is called. If you don't have a cron on the server you can do the following.
1. Write a PHP script that is visible over HTTP
2. Run cron job on some machine you have access and that has cron, could be even Windows one with Scheduler (never tester) that has the wget utility:
wget http://serverip.host.or.ip.here/script.php
This command should be executed every 15 minutes.

HTH

Andrey Hristov, Software Developer
MySQL AB, www.mysql.com