[Snort-users] Empty MySQL DB

Roman Danyliw roman at ...438...
Fri Feb 8 13:11:37 EST 2002


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





More information about the Snort-users mailing list