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