RE: Mysql archive question?

["Grimes, Shawn (NIA/IRP)" <GrimesSh () grc nia nih gov>]

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 () grc nia nih gov 


-----Original Message-----
Message: 6
Date: Mon, 12 Nov 2001 11:02:49 -0500
From: Vjay LaRosa <vjayl () emc com>
To: snort-users () 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


_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users