How to make FR reset the logs

[Guy Fraser]

On Wed, 2006-05-04 at 22:06 +0300, Mordor Networks wrote:
> Date: Wed, 05 Apr 2006 11:09:58 -0600
> From: Guy Fraser <guy at incentre.net>
> Subject: Re: How to make FR reset the logs
> To: freeradius-users at lists.freeradius.org
> Message-ID: <1144257000.9277.140.camel at sigurd.incentre.net>
> Content-Type: text/plain
> 
> On Wed, 2006-05-04 at 06:15 +0300, Mordor Networks wrote:
> > hi
> > Is it possible to make FR remove all monthly accounting logs from
> the 
> > database "mysql"?
> 
> Yikes, why would you want to do that?
> 
> Thanks for your reply . i have pppoe-server with FR and mysql and
> dialup_admin , and 600 user , so i have a lot of traffic and logs
> daily/monthly 

I don't use MySQL very often so do not know for sure if this would 
work, but here goes a simple example :

select * into radacct_old from radacct where AcctStopTime < '2006-04-01
00:00:00' ;

delete from radacct where AcctStopTime < '2006-04-01 00:00:00' ;

vacuum;

If you intend on using MySQL you will need to learn how to use
it. There are many functions and some may help you do what 
you want.