How do I trim my CDRs

General Help
1

I have been running my Asterisk box for a long time and the CDR file is very large and it takes some time to bring up Reports. I was wondering if there is a ‘proper way’ to trim the file and archive the trimmed off records. I would like to have maybe the last few months or maybe even the last year active and the rest just backed up.

Thanks in advance

2

All of the records are stored in mysql table. So you just need to run some mysql commands against the asteriskcdrdb database, table cdr. If you have phpmyadmin installed you can do it all from the web gui it provides (export, select and delete).

3

See my posting and details over here for a couple of ways –

http://www.trixbox.org/forums/trixbox-forums/help/mysql-cdr-table-size

4

I figured someone had to have done it.
I searched trixBox.org first, guess wrong search terms.
Thanks for the pointers.