17 Using MySQL with some common programs

17.1 Using MySQL with Apache

The contrib section includes programs that lets you authenticate your users from a MySQL database and also let you log your log files into a MySQL table. See section B 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.