Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Updated using 4PSA automated script

...

  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);


Content by Label
labels
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@5d4a10c14PSAKB
showSpacefalse
sortmodifiedshowSpacefalse
reversetrue
typepagecall reports MySQL voipnow
cqllabel in ("reports","mysql","voipnowcall","callhistory") and type = "page" and space = "4PSAKB"

...

hiddentrue

...

currentSpace()
labelscall reports MySQL voipnow

Except where otherwise noted, content in this space is licensed under a Creative Commons Attribution 4.0 International.