OK. I'm in the same boat - not being a db-admin. But it seems to me that a database ought to have some kind of feature that allows an admin to 'remove all records built before <date and time>'. That would seem to be a more efficient way of cleansing a db.
I will check out dialup_admin. That is supposed to support mysql databases, I see. Thanks, Mike -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Dave Vondracek Sent: Thursday, November 21, 2002 11:28 AM To: [EMAIL PROTECTED] Subject: Re: Using MYSQL for accounting only Mike, I haven't really looked into this, as I've only run the mysql accounting for a couple months, and we need the data much longer to reconcile with some of our providers. I'm planning on doing it by hand with a simple sql statment based on AcctStartTime or AcctStopTime for the time being. I have seen reference to dialup_admin being able to handle this as well. I've not yet had time to investigate dialup_admin though. I'm sure I've missed alot of the DB nuances, as I'm an SA, not a DBA. But it gets the job done. :) dave On Thu, 21 Nov 2002 10:13:39 -0800 "Mike Denka" <[EMAIL PROTECTED]> wrote: > > > Thanks to Dave and Kostas for the feedback. Sounds > great. So now I'm > wondering how you age the accounting data if it all goes > to a mysql db. > You would certainly not want to keep accounting data > indefinitely. So > what process do you guys use to throw out the old stuff > to make way for > the new? (Forgive me if this is obvious in the context > of databases - > I'm really not a very literate database guy). > > Thanks again, > > Mike > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
