Some suggestions: 1) Setup the sql query so that it inserts into the radacct_YYYYMM table, or something similar. You can do this by using 'radacct_%Y%m' for the table name. One problem with this would be at the end of the month when a new table is used, the accounting stop records won't match up with their start records.
2) Add a timestamp field to the table and have it set to NOW() when the record is updated. Then write a script to move the old data to another table after some period of time. Just some ideas that popped into my head. I'm sure there's an easier solution out there somewhere.... Kevin On Friday 20 September 2002 11:40, Mike Hendrix wrote: > I have a question about moving accounting data out of a SQL database. We > are planning on running freeradius 0.7.1 on RH 7.3 using mySQL for > accounting. What do people do here to move the old accounting data out of > the radacct table in such a way that you don't loose any new accounting > records? We are ready to implement and am looking for some suggestions on > how this could be done safely... > > ----------------------------------------------- > "I have not failed. I've just found 10,000 ways > that won't work." - Thomas Edison > > Michael Hendrix [EMAIL PROTECTED] > Systems Engineer / SysAdmin Team Leader > Logical Net / Capital Net (518) 292-4509 > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
