Jim,
> TERMINATED BY ' ' to indicate that the fields are space deliminated
> LINES TERMINATED BY '\n' to indicate that each line is terminated by
> new lineagain I'm thinking here that
> I may need to use a '\r' instead.
As a rule of thumb, depending on where your logs come from:
a)
or my application I had to be sure that the input was 100.00 % ok.
Jerry
- Original Message -
From: "James Kelly" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 21, 2003 2:02 PM
Subject: Checkpoint FW1 logs into mysql
> Hello all
> I&#
> I'm trying to work out how to import Checkpoint FW1 firewall logs into
> mysql.
>
> Each line of the logs consists of 27 space deliminated fields.
> Of the 27 fields, I want to ignore about 11 of these fields when I do
> the LOAD command on the log file.
>
> I've already figured out I want to use
Hello all
I'm trying to work out how to import Checkpoint FW1 firewall logs into
mysql.
Each line of the logs consists of 27 space deliminated fields.
Of the 27 fields, I want to ignore about 11 of these fields when I do
the LOAD command on the log file.
I've already figured out I want to use:
