MySQL radacct backup

[David]

>> 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.
>
>Ivan Kalik
>Kalik Informatika ISP
>
You may also create your table with the archive engine to save space: 1:4 if
my memory is correct. The downside is there's no index so it takes more time
to query your table, but that's for occasional use I suppose

David Roze
----
http://www.netexpertise.eu