19 Using MySQL with some common programs

19.1 Using MySQL with Apache

The contrib section includes programs that let you authenticate your users from a MySQL database and also let you log your log files into a MySQL table. See section C Contributed programs.

You can change the Apache logging format to be easily readable by MySQL by putting the following into the Apache configuration file:

LogFormat 
        ""%h",%{%Y%m%d%H%M%S}t,%>s,"%b","%{Content-Type}o",  
        "%U","%{Referer}i","%{User-Agent}i""

In MySQL you can now do something like this:

LOAD DATA INFILE '/local/access_log' INTO TABLE table_name 
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\'

Go to the first, previous, next, last section, table of contents.