automated updates from flat file

[Anon]

I run an Apache Web server on a redhat 7.2 machine with php 4.0.6 and Mysql 3.23.X

My interface is a database search, plain and simple.
But what I need is for a batch file or some script to read information from a flat text
file (I delimit my feilds with commas) and update the database with the new information on a scheduled time basis. A new flat text file is sent to the machine daily.

I used the command;
mysql> load data infile "flattext.txt"
-> fields terminated by ","
-> ;

That got my data from the file as needed. I just need it to do it automatically, on a schedule.

[bacil]

Hi!

Try to include header to your Index.php.
When Index.php is accessed ( hope at least once a day) you can execute your SQL command from PHP(and check date, time)

i've written script like this but i couldn't find it.

but try this idea..

Ivan

[Anon]

If you're running Linux, why not use cron?

Possible solution:
Generate a script file containg your mysql command i.e.

load data infile "flattext.txt" fields terminated by "," ;

and then put an entry in crontab with the cron command as

mysql < (path_to_ur_script)/my_upload_script

Cron can be set to run whenever you like and with whatever interval you like (down to about a 1 second timeslice).

Cheers

Justin