Snort mailing list archives
FW: Mysql archive question?
From: "Hutchinson, Andrew" <Andrew.Hutchinson () Vanderbilt edu>
Date: Mon, 12 Nov 2001 12:25:22 -0600
The data that you're trying to load already exists in the archive database, and you're trying to write a unique index record when a record with the same unique key is already there. I would have to know how you're dumping the data to files to know exactly why this is happening, but you'll need to do one of the following for it to work right: Solution 1: 1. Perform complete database dump. 2. Purge data from tables in production database. 3. Load data to archive database. This will ensure that there is no data collision between the databases. If you don't purge the production data, then the next time you dump and load, you'll be loading unique values that already exist. Solution 2: 1. Create a field or table in the production database that tracks which records have been archived, and write a custom script to dump the data that updates this field or table. This will be slower. 2. Load only the un-archived data into the archive database. Solution 2 is more complex, and probably defeats the purpose of archiving in the first place - reducing the size of the production database to increase performance. Hope this helps. Andrew Hutchinson CNE MCSE Informatics/NCS/Network Security Vanderbilt University Medical Center 615.936.2856 - voice 615.936.0643 - fax andrew.hutchinson () mcmail vanderbilt edu
-----Original Message----- From: snort-users-admin () lists sourceforge net@VANDERBILT On Behalf Of Vjay LaRosa <vjayl () emc com> Sent: Monday, November 12, 2001 10:03 AM To: snort-users () lists sourceforge net Subject: [Snort-users] Mysql archive question? 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
Current thread:
- Mysql archive question? Vjay LaRosa (Nov 12)
- <Possible follow-ups>
- FW: Mysql archive question? Hutchinson, Andrew (Nov 12)
- RE: Mysql archive question? Grimes, Shawn (NIA/IRP) (Nov 13)