| ||||||||||||||||
 | ||||||||||||||||
 |
|
|
||||||||||||||
|
|
|||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
|
|
|
||||||||||||||
|
|
|||||||||||||||
| ||||||||||||||||
| ||||||||||||||||
MySQL with some common programsThe 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.
| ||||||
|
|
|||||
| ||||||
|
||||||