Re: MySQL radacct backup

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