MySQL Reference Manual for version 3.23.15-alpha. - 18 Using MySQL with some common programs Go to the first, previous, next, last section, table of contents. 18 Using MySQL with some common programs 18.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 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.