[Snort-users] Database clean up
sasa.jusic at ...7849...
Mon Jan 27 08:23:04 EST 2003
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
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,
More information about the Snort-users