I have a Perl script that I use to parse and insert all my Unix logfiles
into a MySQL server. I can post the script if you would like to have / view
/ steal of whatever.
-Paul
----- Original Message -----
From: "Dennis Salguero" <[EMAIL PROTECTED]>
To: "Charles Henderson" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 28, 2001 5:04 PM
Subject: Re: MS IIS web logfiles
> ----- Original Message -----
> From: "Charles Henderson" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, June 28, 2001 4:33 PM
> Subject: MS IIS web logfiles
>
>
> > How can I get mySQL to create a table for a IIS web logfile (*.log) ?
The
> > file is very long (maybe 1 million records +) and there are 16 space
> > separated data fields (17 if you include a autocount as primary key).
I
> > know that MS Access has a GUI Wizard that walks you through the
conversion
> > of text files to an Access table. Unfortunately, my data is much to
large
> > for MS Access (or a text reader). I find no comparable facilitation
with
> > mySQL. Any suggestions?
>
> Well, unfortunately that's one of the trade-offs between a "database" like
> Access and something more robust like MySQL. MySQL (and most other large
> database packages) do not always have these GUI tools to facilitate
> conversions and other operations.
>
> Therefore, perhaps the best long-term solution for your need is to create
a
> VB program (or the language of your choice) to take a delimited text file
> and put it into its own table in MySQL (or any other database really). As
> long as you can access the file and know the delimiter (both of which are
> possible with IIS log file), then this program should not be difficult to
> put together.
>
> Good Luck,
>
> Dennis
> **********************************************
> Beridney Computer Services
> http://www.beridney.com
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
