Re: snort DB clean

[Frank Carreiro <fcarreiro () loweryinc com>]

There should be some cleaner way to do this.  I've been looking at the 
tables created and believe there must be some day to use the delete 
command and delete based on the timestamp.  I noticed a "cis" field in 
the tablespaces.  Looks like some sort of index.  Should be able to 
build something referencing that.

I'll play with it now and then.  It's rather low on my priority list 
(for now).  Sooner or later I'll have to get serious about it though. 
For now I've simply used phpMyadmin to drop certain signatures then 
optimize the database.  It works but still a dirty way to maintain the 
MySql database.

Frank



> Message: 2
> Date: Fri, 15 Mar 2002 16:25:28 +0200
> From: Claudiu Ionescu <jones () rdsnet ro>
> To: snort-users () lists sourceforge net
> Subject: Re: [Snort-users] snort DB clean
>
> At the extreme you can drop the database and create it again:).... just add few lines
> at the begining of the create_database script. For mySQL would be something like :
>
> DROP DATABASE IF EXISTS snort;
> CREATE DATABASE snort;
> GRANT INSERT,SELECT on snort.* to snortuser@localhost;
> USE snort;
> here the original create_mysql


_______________________________________________
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