Hi,
I have a general question regarding CDR data, would the old recorded data eventually erased over time or all CDR data is kept in MySQL database unless manually deleted/modified?
I would like to keep CDR data for certain period of time, (say 2 years) and wondering what would be the recommended way of backing up the data.
Many thanks in advance,
you can do āeventually erased over timeā manually;
And for backing up;
you can use ābackup and restoreā module,
Hi Nbthost,
Thanks for the reply. Quick confirmation, if I donāt touch manually, CDR data will remain and keep accumulating overtime? (Which is preferable, I am thinking about taking periodical backup but if the data is keep accumulating, I can keep several of latest backup archive and throw away old onesā¦)
Yes, if you do not touch, the data keep accumulating.
And yes, you can take several backups with ābackup and restoreā module and download them with ftp using filezilla. You can find backups in /var/spool/asterisk/backup
Super! As long as the CDR data retains until manual intervention, I can keep several latest backups and delete the rest. Thanks for the clarification, have a nice weekend!
Hi, quick question, did you try enabling automatic backup feature? I am experimenting to backup periodically, (such as hourly, daily, weekly) somehow I donāt see archive in /var/spool/asterisk/backup folder. If I press āand Runā button manually, it creates backup, but just by pressing āsaveā button wonāt schedule automatic backupā¦
I use 2 backup templates;
one is daily the other is weekly
one of my backup schedule;
you will only press āsaveā button. if you press ārunā button it will take manual backup
it takes automatically every night;
and when takes 7 backups, deletes the oldest one.
FYI, my issue was not having /home/asterisk directory. Thanks for the information!