**DRAFT** Backing up & restoring the CIS-CAT Pro Dashboard v3 Database

Problem

The CIS-CAT Pro Dashboard v3 MariaDB database and its contents (imported assessment results, tags, user accounts) needs to be backed up. This backup can also be restored to a new server of the same Dashboard version.

Solution

Windows

Windows Backup

• Open services.msc and stop the CCPD_Windows service

• Launch an administrative cmd.exe prompt

• Back up the existing Dashboard DB:

  mariadb-dump -u root -p -x -A > C:\ccpdbackup\ccpd_db.sql

  Note: The destination directory (C:\ccpdbackup\ in this example) has to be an existing folder.

  • -u root -p: Use the root user and supply the MariaDB password when prompted

  • -x: Lock all tables during this operation

  • -A: Export all databases to the file

• Open services.msc and start the CCPD_Windows service to resume Dashboard again

Windows Restore

• Open services.msc and stop the CCPD_Windows service

• Launch an administrative cmd.exe prompt

• Restore the previously created backup:

  mariadb -u root -p < C:\ccpdbackup\ccpd_db.sql

• Open services.msc and start the CCPD_Windows service. The backed up database contents should now appear in the current deployment.

Linux

Linux Backup

• Test & add commands

Linux Restore

• Add commands

Keywords; ccpd dashboard database backup restore mariadb

Content by Label

• Page:
  Feature Enhancement Requests for CIS Products