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....@lists.freeradius.org [mailto:freeradius-users-bounces+avkosykh=gmail....@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 <t...@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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html