Here's a MySQL table definition that can hold the log data:
CREATE TABLE weblog (
   when         DATETIME NOT NULL,
   duration     INT(4),
   uri          VARCHAR(255) NOT NULL,
   query_string VARCHAR(255),
   status       CHAR(3) NOT NULL,
   method       CHAR(3) NOT NULL,
   mime_type    VARCHAR(32) NOT NULL,
   bytes        INT(8),
   vhost        VARCHAR(64),
   referer      VARCHAR(255),
   browser      VARCHAR(64),
   remote_addr  VARCHAR(15),
   cookie       VARCHAR(255),
   authuser     VARCHAR(255)
);
Splitting the fast parsable log format fields into arguments for insert statements into this table is easy.
Slide 13 of 18 Contents
  1 |   2 |   3 |   4 |   5 |   6 |   7 |   8 |   9 | 10
11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
www.arachna.com > Educational Resources > Conference Presentations

spidaman
© 1999-2008 Ian Kallen | Copyright Notice