> > another way to do it is to write a small perl (or whatever) program > which reads apache log entries on stdin and injects them into a database > - should be less than 20 lines of perl using DBI. >
but the problem is, i cant code in PERL :-( any good souls out there who have the free time to write that 20 lines of code ? :-) cheers, chad PS. i recently found out that you can actually use mysql itself to read a datafile and inject it to some table. that can be done by: LOAD DATA INFILE '/var/log/apache/access.log' INTO TABLE table_name FIELDS TERMINATED BY ' ' OPTIONALLY ENCLOSED BY '"'; since apache logs "date/time" (%t in apaches LogFormat) inside an "[" and an "]", i replaced all "[]"'s w/ an '"' ... everything seemed to have worked very well and very smoothly until i found out that some User-Agent logs contains something like ""Mozilla/4.6 "en" (Win95; I)"" ... the "en" thingy confused that MySQL directive :-( ... any inputs anyone ??? thanks again.
