PHP/SQL stats tracking?

[malfunkshun]

Evening
Basically I need to transfer, by FTP, the contents of a text file to a MySQL table so that I can call the table(s) in php and output the results to a web page. I think that I have the second part of this but have no idea about getting the data from one server to MySQL and into tables so that I can call it.
I seem to recall some of you doing this for stats tracking previously, any help appreciated.

 

[malfunkshun]

Time stamped, delimited (semi colon). It is a text file, generated by an application in real time, no database. I need FTP the contents to another server where it can be put into a MySQL db so that I can then extract the desired data so that I can use PHP (or similar/better) to process the data into a format that can be output for inclusion on a webpage. It will also be a requirement that after the initial dump the database is appended at a given interval, not a complete dump everytime.

Anyway, the thing that is killing me (at the moment, there will likely be other problems) is obtaining the data from the remote server for processing.

 

[malfunkshun]

thread revival time. Been busy with other things

for clarity, I need to access a flat file via ftp (preferably at a given time) is this even possible with php?
I can handle the data once I get it, I just dont know how to get it
Ahh ok, it is possible to download the file from FTP file 'a' to open local file 'b', the problem is that the file will get progressively larger (currently a hair over 1gb) so I dont want to have to transfer the entire file every time....any ideas?

 

[malfunkshun]

Yeah the plan is to use the data to update some mySQL tables. What I need to do is just access the most recent data from the original text file instead of all of it (1gb and progressively larger file gets and insertions on a daily basis would probably get my hosting accounts dropped)