Re: ACID db management

[Paul Schmehl <pauls () utdallas edu>]

--On Friday, September 05, 2003 12:54:19 -0600 "DeBerry, Casey" 
<Casey.DeBerry () trizetto com> wrote:

> I need to create a sql dump once a week from my snort/acid mysql
> database... What are the relevant tables that I should be dumping from,
> and what tables can I clear after I have created that dump?
> In essence, I want to start with a clean database once a week, having
> backed the data up beforehand.
You need my archiving script.  I wrote it with the help of two other 
people.  It allows you to either delete or archive records on a schedule 
that you choose.  I keep seven days in my snort db and every night (through 
cron) archive the eighth day.

Email me privately and I'll send you the script and config file.

Paul Schmehl (pauls () utdallas edu)
Adjunct Information Security Officer
The University of Texas at Dallas
AVIEN Founding Member
http://www.utdallas.edu


-------------------------------------------------------
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