Product Name
CIS-CAT Pro Dashboard
Product Version
v3
Date
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
Restoring a database backup will overwrite the existing contents of the Dashboard database. Please proceed with caution when performing this operation.
Windows
It is recommended to use cmd.exe rather than PowerShell for the below operations, as PowerShell may change the formatting of the generated .sql file.
Windows Backup
Open
services.mscStop the
CCPD_WindowsserviceEnsure the
MariaDBservice is running
Launch an administrative
cmd.exepromptBack up the existing databases to a single file:
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 therootuser and supply the MariaDB password when prompted-x: Lock all tables during this operation-A: Export all databases to the file
Open
services.mscand start theCCPD_Windowsservice to resume Dashboard again
Windows Restore
Open
services.mscStop the
CCPD_WindowsserviceEnsure the
MariaDBservice is running
Launch an administrative
cmd.exepromptRestore the previously created backup from the
.sqlfile:mariadb -u root -p < C:\ccpdbackup\ccpd_db.sql
Open
services.mscand start theCCPD_Windowsservice. 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_DashboardEnsure the MariaDB service is running:
sudo systemctl start mariadbBack up the existing databases to a single file:
mariadb-dump -u root -p -x -A > /home/user/ccpd_db.sql
Note: The destination directory (
/home/userfor example) needs to be an already existing folder.-u root -p: Use therootuser 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_DashboardEnsure the MariaDB service is running:
sudo systemctl start mariadbRestore the previously created backup from the
.sqlfile: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.
0 Comments