I've do a whole load of log parsing/loading/analysis. And I mean A WHOLE load :)
I found it better to use a pre parse (script/binary/program) to filter the logs then dump out the SQL. That way you can do some filtering and error checking on the logs before they get near the dB. Though for 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'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: > > TERMINATED BY ' ' to indicate that the fields are space deliminated > LINES TERMINATED BY '\n' to indicate that each line is terminated by > new line....again I'm thinking here that > I may need to use a '\r' instead. > > Question: how do I get mysql to ignore specified fields? I will be > using a LOAD file to contain the load parameters and that the field > options are top to bottom for fields left to right. > > **When I come to a field I want mysql to ignore do I just use this > parameter? > IGNORE > > > jim kelly > > > --------------------------------------------------------------------- > 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
