Product Name
CIS-CAT Pro Dashboard
Product Version
v3
Date
Table of Content Zone | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Problem
The CIS-CAT Pro Dashboard v3 MariaDB database and its contents (imported assessment results, tags, exceptions, user accounts) needs to be backed up and then restored at a later time, either to the existing or a new Dashboard instance of the same version.
Solution
Note |
---|
Restoring a database backup will overwrite the existing contents of the Dashboard database. |
Windows
Info |
---|
It is recommended to use |
Windows Backup
Open
services.msc
Stop the
CCPD_Windows
serviceEnsure the
MariaDB
service is running
Launch an administrative
cmd.exe
promptBack up the existing databases to a single file:
Code Block mariadb-dump -u root -p -x -A > C:\ccpdbackup\ccpd_db.sql
Note: The destination directory (
C:\ccpdbackup\
for example) needs to be an already existing folder.-u root -p
: Use theroot
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 theCCPD_Windows
service to resume Dashboard again
Windows Restore
Open
services.msc
Stop the
CCPD_Windows
serviceEnsure the
MariaDB
service is running
Launch an administrative
cmd.exe
promptRestore the previously created backup from the
.sql
file:Code Block mariadb -u root -p < C:\ccpdbackup\ccpd_db.sql
Open
services.msc
and start theCCPD_Windows
service. The backed up database contents should now appear in the current Dashboard deployment once the application startup completes.
Ubuntu 20.04
Ubuntu Backup
Stop the Dashboard service:
sudo systemctl stop CIS-CAT_Pro_Dashboard
Ensure the MariaDB service is running:
sudo systemctl start mariadb
Back up the existing databases to a single file:
Code Block mariadb-dump -u root -p -x -A > /home/user/ccpd_db.sql
Note: The destination directory (
/home/user
for example) needs to be an already existing folder.-u root -p
: Use theroot
user and supply the MariaDB password when prompted-x
: Lock all tables during this operation-A
: Export all databases to the file
Start the Dashboard service to resume the application:
sudo systemctl start CIS-CAT_Pro_Dashboard
Ubuntu Restore
Stop the Dashboard service:
sudo systemctl stop CIS-CAT_Pro_Dashboard
Ensure the MariaDB service is running:
sudo systemctl start mariadb
Restore the previously created backup from the
.sql
file:Code Block mariadb -u root -p < /home/user/ccpd_db.sql
Start the Dashboard service:
sudo systemctl start CIS-CAT_Pro_Dashboard
The backed up database contents should now appear in the current Dashboard deployment once the application startup completes.
Keywords; ccpd dashboard database backup restore mariadb
Content by Label
Filter by label (Content by label) | ||||||
---|---|---|---|---|---|---|
|
Page Properties | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||
|