MySQL radacct backup

Evgeniy Kozhuhovskiy ugenk at
Wed May 13 19:50:31 CEST 2009

Ivan Kalik 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.

May be better to modify queries to use tables with names like 
radacct-%YYYY-%m (and precreate them)?

With best regards, Evgeniy Kozhuhovskiy
Leader, Services team
Minsk State Phone Network, RUE Beltelecom.

More information about the Freeradius-Users mailing list