Folks,

The new snort implementation is going well. However, I'm getting to the point where I need to start worrying about MYSQL database maintenance. I was wondering if anyone has any good scripts for things like archiving. I'm sure I could spend the time and dig through the mysql documentation and hack one together, but I'm sure someone has already written a better script than anything I could write. Also any advice on general database maintenance is welcome.

Thanks

byron

One thing to be careful of, the mysqldump utility dosn't properly escape database keywords when dumping. For example, if you have a field named date, date is one of the specified mysql keywords, so although it will dump fine, reinserting will give you an error.

Sorry I cant give you any more specifics, I use Postgres now (after getting annoyed with said dump utility)

Good to know none-the-less.

Thanks