13 May
2009
13 May
'09
1:50 p.m.
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.