Hello all,
I have what might be a how-to, but because I know that I don’t know, I’ll ask those who do first. Is this safe to run to clear out the CDR database?
I do the following:
- SSH to the server
- Type the following commands:
List databases:
Select the CDR DB:
List the tables in the database:
To view the columns:
To view the rows:
[code]mysql> select src
,duration
,dst
FROM cdr
WHERE duration
>= 0;
To CLEAR the CDR Table:
For those wondering why I would even need to clear the CDR - we had been imaging our PBXes from whatever test box is in the office at the time. But now we are using a master image where the CDR is now cleared. But I still wanted to ask anyway, and if this is safe to do, I hope this helps others asking the same questions.