Technical Tip: Restore FortiNAC Database from CLI

Description

This article describes how to restore the FortiNAC Database via CLI in case the Database was corrupted.

Scope

FortiNAC.

Solution

Restore the FortiNAC database from the CLI:

Typical scenarios:

• The disk fails on a RAID-less appliance.

• The appliance has been reset to factory defaults, and it is necessary to restore the pre-reset remote backup of the database.

• The FortiNAC hardware is upgraded, and it is expected to restore the most recent remote backup from the previous FortiNAC appliance.

Procedure:

1. Copy (e.g., use winscp) the most recent backup from the remote server to the /bsc/campusMgr/master_loader/mysql/backup directory on the FortiNAC Control Server. Alternatively, it is possible to revert back to an automatic backup created automatically by FortiNAC in the backup folder.

2. Log into the CLI on the Control Server with root privileges.

3. Stop the FortiNAC processes:

shutdownNAC

4. Navigate to the /bsc/campusMgr/master_loader/mysql/backup directory and identify the filename of the backup to be used.

Example: FortiNAC_DataBase_BackUp_2021_12_13_00_01_07_fnac88-std1.gz.

5. Navigate to the /bsc/campusMgr/master_loader/mysql directory and restore the database.

Example:

ydb_restore_full_backup FortiNAC_DataBase_BackUp_2021_12_13_00_01_07_fnac88-std1.gz 

For FortiNAC-F, navigate to /bsc/backups/database/ directory and use the sudo command.

fnac:/bsc/backups/database$ sudo 
ydb_restore_full_backup <database_name>

Or:

fnac76  # execute restore database
local <database_name>

6. Start the FortiNAC processes:

startupNAC

Related documents:

• FortiNAC Backup and Restore Version: v8.x

• FortiNAC-F backup and restore GUIDE 

• FortiNAC-F: Local Backup File Locations