TIPS Delete CDR reports

kmcdaniel

Member
Joined
Jan 23, 2008
Messages
416
Reaction score
19
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
19,168
Reaction score
5,199
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

Member
Joined
Jan 23, 2008
Messages
416
Reaction score
19
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'
 

krzykat

Telecom Strategist
Joined
Aug 2, 2008
Messages
3,145
Reaction score
1,235
The CDR is clear, do I need to locate the unknown database to avoid any issues?

If you want to verify table names and content, I recommend you learn to use phpmyadmin
 
Get 3CX - Absolutely Free!

Link up your team and customers Phone System Live Chat Video Conferencing

Hosted or Self-managed. Up to 10 users free forever. No credit card. Try risk free.

3CX
A 3CX Account with that email already exists. You will be redirected to the Customer Portal to sign in or reset your password if you've forgotten it.
Top