Re: Mysql cleanup script?

[quentyn () fotango com]

Nathan Whitehouse wrote:
> Dose anyone have a Mysql cleanup script?
> Something I can run once a week or month to clean out my Mysql database for
> snort alerts.
>
> Thanks



if all you want to do is zap out all alerts why not just 

mysqldump <my db> --no-data -u -p > structure (only needs to be done
once)
mysqladmin drop <my db> -u -p && mysqladmin create <my db> -u -p
mysql <my db> -u -p < structure

which is a bit sledge hammery ( if there is such a word) 


This looks like what you want 

http://archives.neohapsis.com/archives/snort/2000-12/0458.html



-- 
#####################
Quentyn Taylor
Sysadmin - Fotango
#####################
"Beauty is in the eye of the beer holder..." 
   Anon.


-------------------------------------------------------
This SF.net email is sponsored by: ApacheCon, November 18-21 in
Las Vegas (supported by COMDEX), the only Apache event to be
fully supported by the ASF. http://www.apachecon.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