MySQL ibdata1 database too big

In an old VitalPBX installation the database file ibdata1 has a size of 16Gbytes
Unfortunately I am not able to upgrade the version to the latest one, although I tried.
Version : 2.1.1-1
Asterisk : Asterisk 13.23.1
Can I truncate the database ?

What happens when you try to upgrade?

It’s been a while since I tried to upgrade multiple times and I had to restore the VM every time.
This is not my main concern.
I am concerned about the size of the ibdata1 database.

AfAIK, that contains CDR. Try to shrink your CDR (and maybe CEL) tables, optimize the DB and see if it shrinks.

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.