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.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
