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
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
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'm trying to work out how to import Checkpoint
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)