Re: Empty MySQL DB

[Roman Danyliw <roman () danyliw com>]

Pipe this into database:

[--snip--]
DELETE FROM data;
DELETE FROM event;
DELETE FROM icmphdr;
DELETE FROM iphdr;
DELETE FROM opt;
DELETE FROM reference;
DELETE FROM reference_system;
DELETE FROM sensor;
DELETE FROM sig_class;
DELETE FROM sig_reference;
DELETE FROM signature;
DELETE FROM tcphdr;
DELETE FROM udphdr;
[--end--]

cheers,
Roman

On Fri, 8 Feb 2002, Warrick FitzGerald wrote:

> Hi All,
>
> Does anyone know of a simple script that cleans out a snort MySQL DB ...
so
> I can start from fresh. Not to hard to do, but why do it again if there
is a
> tool out there already ?
>
> Thanks
> Warrick


_______________________________________________
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