(mysql.info.gz) Apache

Info Catalog

(mysql.info.gz) Twin

(mysql.info.gz) Tutorial

 
 3.8 Using MySQL with Apache
 ===========================
 
 There are programs that let you authenticate your users from a MySQL
 database and also let you write your log files into a MySQL table.
 
 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\""
 
 To load a log file in that format into MySQL, you can use a statement
 something like this:
 
      LOAD DATA INFILE '/LOCAL/ACCESS_LOG' INTO TABLE TBL_NAME
      FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\'
 
 The named table should be created to have columns that correspond to
 those that the `LogFormat' line writes to the log file.
 

Info Catalog

(mysql.info.gz) Twin

(mysql.info.gz) Tutorial