Hi. I wrote a perl script which make all this operations. If u wish I'll send it to u by mail. But there is Russians comments on this script:) -----Original Message----- From: freeradius-users-bounces+avkosykh=gmail.com@lists.freeradius.org [mailto:freeradius-users-bounces+avkosykh=gmail.com@lists.freeradius.org] On Behalf Of sub Sent: Wednesday, May 13, 2009 5:25 PM To: FreeRadius users mailing list Subject: Re: MySQL radacct backup 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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html