...
Assuming you are using a CentOS server and your DB credentials on VoipNow credentials are in /etc/voipnow/.sqldb, follow the recommendations below.
| Note |
|---|
If you are not sure of what you are doing, it's recommended to do a backup of the call_history and ast_cdr tables either in a file, or through an import to a different database. |
Deleting records older than X years
...
- Log in to MySQL as explained above.
Then run the following command. It will delete all records older than 6 months.
Shell DELETE FROM ast_cdr WHERE calldate < DATE_SUB(NOW(), INTERVAL 6 MONTH);
DELETE FROM call_history WHERE cr_date < DATE_SUB(NOW(), INTERVAL 6 MONTH);
...
Related articles
| Content by Label | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
| Page properties | ||
|---|---|---|
| ||
|
Except where otherwise noted, content in this space is licensed under a Creative Commons Attribution 4.0 International.