13 May
2009
13 May
'09
9:24 a.m.
On Wed, May 13, 2009 at 14:12, Ivan Kalik <tnt@kalik.net> 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.
Ok, thanks Ivan. I'll do it. -- sub