Re: Purge all Snort events from MySQL database?

["jon baer" <security () jonbaer net>]

not sure if you meant rotate the data *in* the db or the mysql logs
themselves ...

http://www.mysql.com/doc/en/Log_file_maintenance.html

- jon

----- Original Message -----
From: "Keaton, Lindamaria" <LKeaton () unionsafe com>
To: <snort-users () lists sourceforge net>
Sent: Thursday, September 18, 2003 4:41 PM
Subject: RE: [Snort-users] Purge all Snort events from MySQL database?


Is there away to rotate the mysql logs?

-----Original Message-----
From: jon baer
To: snort-users () lists sourceforge net
Sent: 9/18/03 11:24 AM
Subject: Re: [Snort-users] Purge all Snort events from MySQL database?

hmm not sure there is one ... you can always flush the events via
command
line:

echo "delete from snort.event" | mysql -h 10.10.10.10 -u snort
-pmypassword

- jon

----- Original Message -----
From: "Raj Wurttemberg" <rajw () c64 us>
To: "'Pig-A-Holics Anonymous'" <snort-users () lists sourceforge net>
Sent: Thursday, September 18, 2003 1:22 PM
Subject: [Snort-users] Purge all Snort events from MySQL database?


> Simple question from a Snort noob...
>
> What is the proper method to purge all the Snort events from a MySQL
> database?
>
> Thanks,
> /*Raj*/
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> 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




-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
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



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
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:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
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