Hello all. Thanks for reading and for any advice...
Ok, I have a linux webserver with php/mysql/apache.
Next, there are csv (comma separated values) log files on a user's
WINDOWS machine
(and not on the webserver)
in a local directory of theirs like so:
d:\reports\log_data2004_`\log_data_jan\log_file_ja n.txt
d:\reports\log_data2004_2\log_data_feb\log_file_fe b.txt
etc...
(The \reports\log_data\ has several subordinate folders with txt log
files in each...
Now, I need to get these csv text files from the user's windows machine
and onto the linux server and into mysql...
I am able to manually get a single log file into mysql using LOAD DATA
via the command line, however, I need a good way to load all log files
(from their subordinate folders on the windows box) into the database.
I cannot get (and don't think it works anyways) LOAD DATA to work from
a php script.
SHould I have them upload the individual log files ontoe linux box
and process them there?
And if so, what would be the best way to have php look in a directory
(once the files are on the linux box) and load these files into mysql ?
Any ideas?
Thanks very much!