Ive got a couple of PBXs that have millions upon millions of lines of CDRs going back 5-10 years and its getting impossible to run backups or restores. Is there an easy way to export and delete old CDRs, say anything older than a year? I read the article in the wiki about remote cdr databases but t…

That’s where my syntax came from. Apparently date 1 < calldate < date 2 does not work as it deleted everything in my CDR.

Sorry, I didnt look that closely at your syntax. I just remebered I had one saved for future use. Now I am interested to see if anyone has other suggestions on how to skin the cat.

I’d love to export chunks at a time so I can reimport them if need be, like every month or every year, before deleting them from the PBX.

Use mysqldump with similar condition before the delete, you will get a text file of the soon to be deleted calks that you could import back if necessary

[image] bksales: DELETE from cdr WHERE ‘2018-06-21 09:58:00’ < calldate < ‘2018-06-21 10:00:00’; Working from memory: DELETE FROM cdr WHERE calldate BETWEEN ‘2018-06-21 09:58:00’ AND ‘2018-06-21 10:00:00’;

Did you end up using this cron job on a live system successfully?

I thought we settled for just deleting everything older than a couple months but I just looked and it was never implemented. Will do some testing this weekend.

DELETE FROM cdr WHERE calldate BETWEEN ‘2018-06-21 09:58:00’ AND ‘2018-06-21 10:00:00’; does work but when I copied and pasted it didn’t like the ’ (needs to be a single quote). Its still not clear what optimizing the database does, and I still have no idea how to export everything to a csv from th…

When you work with all this stuff, you need to understand how the shell you are using (probably bash) works with quotes and double quotes. without that knowledge you will remain confused , but luckily we have google to alleviate your angst.

FreePBX Community Forums

How to remove old CDRs

General Help

frankb June 21, 2018, 10:26pm 9

Periodically Delete CDRs Older than N Months General Help

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 …

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled