Re: million entries

["Jon Baer" <security () jonbaer net>]

you could pipe echo commands directly to mysql:

echo "delete from snort.acid_event where signature = x" | mysql -u
snort -pPASS -h localhost

or use phpMyAdmin ...

- jon

pgp key: http://www.jonbaer.net/jonbaer.asc
fingerprint: F438 A47E C45E 8B27 F68C 1F9B 41DB DB8B 9A0C AF47


----- Original Message ----- 
From: "Keg" <snrtlst () netscape net>
To: <snort-users () lists sourceforge net>
Sent: Friday, July 18, 2003 11:43 AM
Subject: [Snort-users] million entries


> I have 1.232.434 entries in the snort  database and I cannot delete
> entries from database using the browser-it just indefenitely hangs there
> on the web page....
> The worst part is that more than a milloin is in a single category so I
> cannot delete entries little by little.
> Is there any way to delete the entries using mysql tools?
> Thanks.
> -- 
> Your favorite stores, helpful shopping tools and great gift ideas.
> Experience the convenience of buying online with Shop@Netscape!
> http://shopnow.netscape.com/`
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: VM Ware
> With VMware you can run multiple operating systems on a single machine.
> WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines at the
> same time. Free trial click here: http://www.vmware.com/wl/offer/345/0
> _______________________________________________
> 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: VM Ware
With VMware you can run multiple operating systems on a single machine.
WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines at the
same time. Free trial click here: http://www.vmware.com/wl/offer/345/0
_______________________________________________
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