RE: Mysql cleanup script?

["Derrick Lichti" <dlichti () mitra com>]

I use phpMyAdmin and here's the script it executes:

REPAIR TABLE `acid_ag` , `acid_ag_alert` , `acid_event` , `acid_ip_cache` , `data` , `detail` , `encoding` , `event` , 
`icmphdr` , `iphdr` , `opt` , `reference` , `reference_system` , `schema` , `sensor` , `sig_class` , `sig_reference` , 
`signature` , `tcphdr` , `udphdr` ;

This doesn't delete alerts, it just repairs the database and cleans it up a little. For example, my DB size was around 
200 MB and after running this, it dropped to 160.

-Derrick

-----Original Message-----
From: Bruce Platt [mailto:Bruce () ei3 com]
Sent: Monday, November 04, 2002 12:49 PM
To: snort-users () lists sourceforge net
Subject: RE: [Snort-users] Mysql cleanup script?

On a similar subject, Over time, even with deleting old alerts, the DB
itself grows.  What's the best way to "shrink" it, so that it takes up less
space on disk?

I thought Roman had posted something like this, but I can't seem to find it.
Or, perhaps I imagined it.

Regards

> -----Original Message-----
> From: Nathan Whitehouse [mailto:nwhitehouse () compendiumusa net]
> Sent: Monday, November 04, 2002 9:04 AM
> To: snort-users () lists sourceforge net
> Subject: [Snort-users] Mysql cleanup script?
>
>
> Dose anyone have a Mysql cleanup script?
> Something I can run once a week or month to clean out my
> Mysql database for
> snort alerts.
>
> Thanks
>
> Nathan Whitehouse
> Network Operations & Systems Administrator
> CompEndium Services Inc.
> Main 877-709-2667
> Local 678-985-5678
> Direct 770-822-6697
>
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.408 / Virus Database: 230 - Release Date: 10/24/2002
>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: ApacheCon, November 18-21 in
> Las Vegas (supported by COMDEX), the only Apache event to be
> fully supported by the ASF. http://www.apachecon.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


-------------------------------------------------------
This SF.net email is sponsored by: ApacheCon, November 18-21 in
Las Vegas (supported by COMDEX), the only Apache event to be
fully supported by the ASF. http://www.apachecon.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


-------------------------------------------------------
This SF.net email is sponsored by: ApacheCon, November 18-21 in
Las Vegas (supported by COMDEX), the only Apache event to be
fully supported by the ASF. http://www.apachecon.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