[Snort-users] RE: Mysql archive question?

Grimes, Shawn (NIA/IRP) GrimesSh at ...3368...
Tue Nov 13 05:12:02 EST 2001


Since it's a perl script you can use the IGNORE mysql statement to ignore
duplicates (that's what my script does anyway).  Presumably, you have a line
that says something like:
LOAD DATA infile $tables[$idx].".arc" INTO TABLE ".$tables[$idx]"
Change it to:
LOAD DATA infile $tables[$idx].".arc" IRNGORE INTO TABLE ".$tables[$idx]"


Thank You,
Shawn Grimes
Computer Specialist
NCTS - Gerontology Research Center
410-558-8007
grimessh at ...3368... 


-----Original Message-----
Message: 6
Date: Mon, 12 Nov 2001 11:02:49 -0500
From: Vjay LaRosa <vjayl at ...3331...>
To: snort-users at lists.sourceforge.net
Subject: [Snort-users] Mysql archive question?


--------------767E0898573B1C874EEFD8AB
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hello,

I seem to be having a problem archiving data in Mysql. When ever I dump
the data out to files, then try and
load it in to my archive data base I always get these errors.

DBD::mysql::st execute failed: Duplicate entry '4-1266285' for key 1 at
./arc-load.pl line 31.
DBD::mysql::st execute failed: Duplicate entry '4-1266285' for key 1 at
./arc-load.pl line 31.

Can any one tell me what might be the problem? Thanks!

vjl


--
 V.Jay LaRosa                           EMC Corporation
 Systems Administrator                  171 South Street
 (508)435-1000 ext 14957                Hopkinton, MA 01748
 (508)497-8082 fax                      www.emc.com





More information about the Snort-users mailing list