Difference between revisions of "CDR MySQL FreePBX database opruimen/oude gespreks-logs wissen"
Jump to navigation
Jump to search
4allbusiness (talk | contribs) |
4allbusiness (talk | contribs) |
||
Line 15: | Line 15: | ||
use asteriskcdrdb; | use asteriskcdrdb; | ||
DELETE from cdr WHERE calldate < '2016-01-01 00:00:00'; | DELETE from cdr WHERE calldate < '2016-01-01 00:00:00'; | ||
+ | OPTIMIZE TABLE asteriskcdrdb.cdr; | ||
+ | exit | ||
+ | |||
+ | '''CEL tabel wissen''' | ||
+ | show tables; | ||
+ | describe cel; | ||
+ | DELETE from cel WHERE eventtime < '2016-01-01 00:00:00'; | ||
OPTIMIZE TABLE asteriskcdrdb.cdr; | OPTIMIZE TABLE asteriskcdrdb.cdr; | ||
exit | exit |
Revision as of 22:09, 1 May 2016
In FreePBX worden CDR CallDetailRecords bijgehouden. De hoeveelheid kan in de loop der jaren flink oplopen, en soms is het wenselijk om alles of een deel te wissen. Dit moet middels de command line in Linux in MySQL.
Wis alle Records:
# mysql show databases; use asteriskcdrdb; delete FROM `cdr` WHERE `duration` >= 0; OPTIMIZE TABLE asteriskcdrdb.cdr; exit
Wis van voor een bepaalde datum bv voor 2016:
# mysql use asteriskcdrdb; DELETE from cdr WHERE calldate < '2016-01-01 00:00:00'; OPTIMIZE TABLE asteriskcdrdb.cdr; exit
CEL tabel wissen
show tables; describe cel; DELETE from cel WHERE eventtime < '2016-01-01 00:00:00'; OPTIMIZE TABLE asteriskcdrdb.cdr; exit