Re: How do I clean up when ACID fails like this?

[Demetri Mouratis <dmourati () cm math uiuc edu>]

On Mon, 24 Feb 2003, Aaron The Young wrote:

> Hello,
>
> I have way too much in my SQL database at this time and
> trying to delete selected alerts causes the following error:
>
> Fatal error: Maximum execution time of 180 seconds exceeded in
> /usr/share/acidlab/acid_db.inc on line 260
>
> I'd love to find a simple way to just erase everything
> in my SQL database until I get my rules set in Snort, but ACID
> doesn't seem able to help me out.
>
> Any suggestions?
You can always drop the DB and then re-create it.

# su - postgres
$ dropdb snort
$ cat create_postgresql | psql snort

There should be some equivalents under MySQL.

HTH.
---------------------------------------------------------------------
Demetri Mouratis
dmourati () linfactory com



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
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