how to reducethe size of cel.MYD file --Asterisk

[actbala]

Hi,

I am using incredible PBX 13, and one of the asteriskcdrdb file cel.MYD size is keeping on inreasing, how to reduce the file size.

Regards,
Balamurugan. P

 

[DoubleDriveLine]

Your best bet is to ask that question at IncrediblePBX forums

VOIP-Info.org






There are 10 kinds of people in the World.

Those that understand Binary and those that don't.

 

[ucxguy]

If you have no use for data in the cel database table, you should consider changing the Asterisk configuration to disable CEL events. That can be done by "enable=no" in the cel.conf (or an included configuration file).

To delete the CEL events from the database table and reclaim the space used by the database table, you should
1. Login into mysql as root or a user that has rights to modify the database (e.g., if the database name is asteriskcdrdb, you would use "mysql -p -u root asteriskcdrdb")
2. Delete all rows in the cel table ("DELETE FROM cel;")
3. Optimize the database table to reclaim the space ("OPTIMIZE TABLE cel;")

 

[actbala]

Hi,

Thanks for your reply, I will try and get back you shortly,

Regards,
Balamurugan. P