Re: SNORT file data.MYD too large

[Edin Dizdarevic <edin.dizdarevic () interActive-Systems de>]

Hi,

Once the tablespace has become so big, MySQL AFAIK will never shrink it
- even if you delete some data inside. This is common to almost all
databases and a remedy should be considered before creating databases.
The best (only?) method is to delete old alerts and alert you do not
need anymore respectively, dump the rest with mysqldump, delete the big
database files, create a new instance and then reimport the data. For a
more detailed answer look on the Internet or at
www.mysql.com...

Regards,
Edin

corrado.riva () alchera it schrieb am 09.02.2005 11:52:
> Hello, I've got a problem with snort db table.
>
> The table data.MYD in /usr/local/mysql/var/snort directory has size 
> of 2,3Gb. My disk partition is quite full and I have to resize the 
> table.
>
> How can I made this operation ?
>
> Thanks a lot !!
>
> Bye
>
> Corrado Riva

--
Edin Dizdarevic


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
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