Page History

...

Assuming you are using a CentOS server and your DB credentials on VoipNow credentials are in /etc/voipnow/.sqldb, follow the recommendations below.

Deleting records older than X years

1. Log in to MySQL with mysql -u <user> -p<password> voipnow. The user and password are in the file mentioned above.

2. Then run the following command. It will delete records older than one year. If you want to delete records older than 2 years, replace 1 with 2.

   Shell
   DELETE FROM ast_cdr WHERE calldate < DATE_SUB(NOW(), INTERVAL 1 YEAR); DELETE FROM call_history WHERE cr_date < DATE_SUB(NOW(), INTERVAL 1 YEAR);

   
   

3. To exit from MySQL, run: 

   Shell
   exit;

   
   

Deleting records older than Y months

1. Log in to MySQL as explained above.

2. 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

...

...