MySQL radacct backup

Ivan Kalik tnt at kalik.net
Wed May 13 14:12:39 CEST 2009


> 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






More information about the Freeradius-Users mailing list