I have a freepbx server that had about 300 endpoints installed. I slowly moved endpoint off to another server and now this PBX only has about a dozen extensions configured. I ran some of the DB commands I saw in the forum to clean up the CDR and CEL tables to delete anything more than 6 months old but the backup files for the PBX is still 4.6G big? It was 4.8G before the SQL commands so I didnt reduce the space that much. What else can I do to cut down on the size of all the tables? The backup of the server takes a considerable amount of time due to the size of the backup file (4.6G after being compressed!). The freepbx is running an old version which is why I am moving everyone off of it but I still have a dozen I cant move yet. Its running FreePBX 15.0.37.8 but at least it has all updates installed, monthly.
I already read that post and used those commands to delete all CDR and CEL records older than 6 months. I was asking about other things to delete that will cut down the size of the PBX Backup file. The commands only saves about 200MB of table space. I verified that my CDR records only go back 6 months now. Not sure what other tables are bloated with entries for all the extensions that were deleted. (there are only 29 old VM messages so its not undeleted VM’s)
How about you look at what is configured to be backed up, and go from there, maybe you are backing up, backups, or maybe you record all calls and have 5 years worth, we are not know
Thanks for the suggestion. I started looking into whats been backed up. Didn’t add anything to the normal “full” backup template in free pbx.CDR Server, Config Server, ASTETCDIR, AMPWEBROOT, AMPBIN, /tftpboot, /etc/dahdi, /etc/wanpipe. Nothing else.
I checked out /tftpboot and its 4G! It looks like even though I deleted the phones and templates the config files never go away. At least I know why the backup is so large.