Hi All, Think I worked it out. Not sure why but will look into it. The lines below: DELETE FROM LOGFILE... are deleting all transactions from the database, even though it has a date/timestamp criteria. Removing '#' this line fixes the problem. I'm going to play with the script and try and work it out. Also will flip a few of the fields around so the script parses the data in the correct format that my squid is outputting. Then all of the reporting scripts should work fine without alteration.. Cheers - Chris.
SET TIMESTAMP=1150769032; INSERT INTO logfile (remotehost,rfc931,authuser,request,status,bytes,time) VALUES ( '10.0.0.143' , '-' , '-' , 'http://b.mail.google.com/mail/channel/bind?' , '407', '1897' , '1150769027' ); # at 1670 #060620 12:03:52 server id 1 log_pos 1670 Query thread_id=5 exec_time=0 error_code=0 SET TIMESTAMP=1150769032; DELETE FROM logfile WHERE time < 1148349832; --------------------------------------------------------------- WHY IS MYSQL NOT POPULATING THE DATABASE?? - Chris.
