Database clean up

["Sasa Jusic" <sasa.jusic () zesoi fer hr>]

Hi everyone,

I am running Snort in IDS mode, and I configured it to log its alerts to
MySQL database. For data analysis and monitoring, I am using ACID in
combination with SnortSnarf.

I would like to know is there any practical way to periodically clean all
Snort's MySQL data, without deleting any tables. With mysqldump I am making
a backup of whole database, but after that I woud like to clean all the data
from it.

With big database, ACID is working very slowly, and SnortSnarf spends a lot
of time when it is tring to generate HTML from MySQL database.

I am tring to make efficient archiving system, which would backup all Snort
log data once at a while (MYSQL database and log dir), and after that clean
the database tables.

Any help appreciated,

Thanks,

Sasa.

















-------------------------------------------------------
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
http://www.vasoftware.com
_______________________________________________
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