16.1 Backing Up the Database

To backup the database, perform the following steps:

  1. Click Backup/Restore in the Administration console on the Global Master server.

  2. Click Backup Database.

    The exported database file is saved in the .cpt format on your local drive.

NOTE:The backup retention policy is specific to each company. However, to comply with federal guidelines, we suggest to set the backup points as follows:

  • Daily(s) for two weeks

  • Monthly(s) for twelve months

  • Yearly(s) for 7 years

16.1.1 Backing Up the Database Through Console

You can use the following procedure along with some third-party modules to automate the backup process:

  1. Run the following command to launch the bash terminal:

    docker exec -it aaf_aucore_1 /bin/bash

  2. Run the following command to navigate to the directory version 2:

    cd /opt/AuCore/aucore/scripts/db_tools/version2/

  3. Run the following command to backup the database:

    ./au_export_encrypt.sh

    NOTE:You can also run the following command to initiate the database backup process instead of performing Step 1 to Step 3:

    docker exec aaf_aucore_1 /opt/AuCore/aucore/scripts/db_tools/version2/au_export_encrypt.sh

    The backed up database file is saved in the following locations in .cpt format:

    • Within the container: /opt/AuCore/data/export/

    • Out of the container: /var/lib/docker/volumes/aaf_aucore-data/_data/export/

IMPORTANT:When you initiate the backup process for the first time, ensure to backup using the Administration portal. If you try Backing Up the Database Through Console for the first time instead of backing up through the administration portal, you might get an error message as follows:

+ pidfile=/etc/nginx/html/static/proc/export.pid

+ '[' -f /etc/nginx/html/static/proc/export.pid ']'

+ echo 17985

./export.sh: line 12: /etc/nginx/html/static/proc/export.pid: No such file or directory