RE: Flushing the data from the MySQL database

["Schmehl, Paul L" <pauls () utdallas edu>]

> -----Original Message-----
> From: Kaplan, Andrew H. [mailto:AHKAPLAN () PARTNERS ORG] 
> Sent: Tuesday, October 14, 2003 8:54 AM
> To: snort-users () lists sourceforge net
> Subject: [Snort-users] Flushing the data from the MySQL database
>
>
> I was running Snort on a trial basis, and I am now ready to 
> have it run in full operational mode. There is a considerable 
> amount of data in the datbase, and I would like to remove it, 
> and start fresh. The database I am using is MySQL 4.0.14. 
> What is the easiest way to do this.

The easiest way I know of is to use the script that I and two other
people have developed.  It allows you to delete or archive db records in
mysql for any period of time that you choose.  I use it to keep 7 days
worth of data in the active db and archive everything else.

If you're interested in it, send me email.

Eric, maybe we should make this available on the site?  If so, how would
I go about doing that?

Paul Schmehl (pauls () utdallas edu)
Adjunct Information Security Officer
The University of Texas at Dallas
AVIEN Founding Member
http://www.utdallas.edu/~pauls/ 


-------------------------------------------------------
This SF.net email is sponsored by: SF.net Giveback Program.
SourceForge.net hosts over 70,000 Open Source Projects.
See the people who have HELPED US provide better services:
Click here: http://sourceforge.net/supporters.php
_______________________________________________
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