TIPS Delete CDR reports

kmcdaniel

Guru
Joined
Jan 23, 2008
Messages
327
Reaction score
11
I've seen reference to this being asked several times in the forum, but no help can be found as to how to accomplish the task. I'm clonign a box and want to start fresh with the CDR records. Can anyone point me in the direction on how to clear the call records for 16-15?
 

wardmundy

Nerd Uno
Joined
Oct 12, 2007
Messages
15,240
Reaction score
2,667
You have to do them separately. Then files are in two separate databases.

mysql -u root -ppassw0rd asteriskcdrdb -e "truncate cdr"
mysql -u root -ppassw0rd asteriskceldb -e "truncate cel"
mysql -u root -ppassw0rd asteriskcdrdb -e "truncate cel"
 
Last edited:

kmcdaniel

Guru
Joined
Jan 23, 2008
Messages
327
Reaction score
11
You have to do them separately. Then files are in two separate databases.

mysql -u root -ppassw0rd asteriskcdrdb -e "truncate cdr"
mysql -u root -ppassw0rd asteriskceldb -e "truncate cel"
Thanks Ward!

The first one took. The second states:
ERROR 1049 (42000): Unknown database 'asteriskceldb'
 

Members online

PIAF 5 - Powered by 3CX

Forum statistics

Threads
22,450
Messages
138,039
Members
14,613
Latest member
roshan2019