RE: db maint

2003-11-18 Thread Dan Greene 
There recently was a thread discussing this with a very nice summary by the person who 
had the issue... do a search on the archives for 'maintaining the size of a db' to 
find the thread

> -Original Message-
> From: M.D. DeWar [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 18, 2003 10:51 AM
> To: [EMAIL PROTECTED]
> Subject: db maint
> 
> 
> Hello
> WARNING::Newbie.
> 
> I have snort running and putting alerts into a mysql database.
> I see that its starting to get big. 
> How does one go about "cleaning" the db ?
> or deleting old data ?
> 
> Thanks
> Mark
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: db maint

2003-11-18 Thread Haydies 
delete from TABLENAME where CONDITION

- Original Message - 
From: "M.D. DeWar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 18, 2003 3:50 PM
Subject: db maint


: Hello
: WARNING::Newbie.
:
: I have snort running and putting alerts into a mysql database.
: I see that its starting to get big.
: How does one go about "cleaning" the db ?
: or deleting old data ?
:
: Thanks
: Mark
:
:
:
: -- 
: MySQL General Mailing List
: For list archives: http://lists.mysql.com/mysql
: To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
:
:


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]