MySQL radacct backup

[Alexander Kosykh]

Hi.
I wrote a perl script which make all this operations.
If u wish I'll send it to u by mail. But there is Russians comments on this
script:)

-----Original Message-----
From: freeradius-users-bounces+avkosykh=gmail.com at lists.freeradius.org
[mailto:freeradius-users-bounces+avkosykh=gmail.com at lists.freeradius.org] On
Behalf Of sub
Sent: Wednesday, May 13, 2009 5:25 PM
To: FreeRadius users mailing list
Subject: Re: MySQL radacct backup

On Wed, May 13, 2009 at 14:12, Ivan Kalik <tnt at kalik.net> wrote:
>> I've a full working freeradius server on an Ubuntu server.
>>
>> My accounting table grows and grows so I'd like to backup my data in
>> any way; before I write my own procedure, does the server (freeradius)
>> provide any utility?
>
> No. CREATE TABLE radacct_old LIKE radacct. Copy entries older than x
> months (INSERT INTO radacct_old SELECT * FROM radacct WHERE ...) and
> delete them from radacct (DELETE FROM radacct WHERE ...) once a month.
>

Ok, thanks Ivan.

I'll do it.

-- 
sub
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html