13 May
2009
13 May
'09
1:40 p.m.
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
You may also create your table with the archive engine to save space: 1:4 if my memory is correct. The downside is there's no index so it takes more time to query your table, but that's for occasional use I suppose David Roze ---- http://www.netexpertise.eu