Importing local text file to mysql database
Posted on 2008-11-14
I have program that logs usage of certain programs to text file.
I would need to import these files to mysql database, and it should be done without user interaction..
What code should i use? I assume some php solution would be best, but i think php cannot read
files from local machine, so it needs to upload the file to the server first?
The program that makes the log file is just .bat file, so i can format the data anyway i like, so that is
not a problem.. lets assume it would be something like this:
Program name, date, time
edit: The automation thing i think i can figure out somehow, but if you have good ideas on this(winodws scheduler or something), please tell me. I would not like to install any additional programs if possible.