How to remove old CDRs

[frankb]

Periodically Delete CDRs Older than N Months

Continuing the discussion from How to clear CDR Database: I have a list of commands I’m considering turning into a cron job. I’ve already tested and when I copy/paste these onto an old PBX system that is not in use, it does successfully work and the CDR database shrinks down from 2+ GB to <300 MB. Does anybody have a better way to do this, or will this create a problem with the PBX itself? mysql use asteriskcdrdb; delete from cdr where calldate < DATE_SUB(NOW(), INTERVAL 6 MONTH); delete …