how to reducethe size of cel.MYD file --Asterisk
how to reducethe size of cel.MYD file --Asterisk
(OP)
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
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
RE: how to reducethe size of cel.MYD file --Asterisk
VOIP-Info.org
There are 10 kinds of people in the World.
Those that understand Binary and those that don't.
RE: how to reducethe size of cel.MYD file --Asterisk
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;")
RE: how to reducethe size of cel.MYD file --Asterisk
Thanks for your reply, I will try and get back you shortly,
Regards,
Balamurugan. P