New accounting database each month

Thor Spruyt thor.spruyt at
Fri Feb 3 00:03:35 CET 2006

Nicolas Baradakis wrote:
>> Is there a way to configure freeradius to create a new MySQL
>> accounting database each month? (in example: jan_06_radacct,
>> feb_06_radacct, etc). The database should be created the first
>> minute of the first day of each month. This is required for
>> backup/database size.

Run a script each month that takes all records from the month before, do
whatever with them and remove them from the database.
I thought databases are especially friendly for stuff like that...

Groeten, Regards, Salutations,

Thor Spruyt
M: +32 (0)475 67 22 65
E: thor.spruyt at

More information about the Freeradius-Users mailing list