RE: Flushing the data from the MySQL database

["Michael Parkinson" <michael () intellnet net uk>]

Dear all,

Sorry to barge in on this particular conversation but I would also be very
interested in the script for clearing down the Mysql DB into archive.

The data I am accumulating does tend to get rather large and automating the
archive process would be a god send.

With thanks

Michael

################################################################

Michael Parkinson BSc(Hons)
Technical Director
Intellnet Limited
5 Priors
London Road
Bishops Stortford
Hertfordshire
CM23 5ED
UK

Telephone       :       01279 602800
DDI             :       01279 602805
Fax             :       01279 602815
Mobile          :       07770 380511
Email           :       michael () intellnet net uk
                        michael () parkinson co uk
Web             :       http://www.ishop.co.uk
                        http://www.intellnet.net.uk

################################################################

-----Original Message-----
From: snort-users-admin () lists sourceforge net
[mailto:snort-users-admin () lists sourceforge net]On Behalf Of Schmehl,
Paul L
Sent: Tuesday, October 14, 2003 3:46 PM
To: Kaplan, Andrew H.; snort-users () lists sourceforge net
Subject: RE: [Snort-users] Flushing the data from the MySQL database


> -----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=ort-users



-------------------------------------------------------
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