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]