Technical Tip: Restore FortiNAC Database from CLI

[Hawada1]

Description	This article describes how to restore the FortiNAC Database via CLI in case the Database was corrupted.
Scope	FortiNAC Database via CLI in v8.8 and above.
Solution	Restore FortiNAC Database from 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: 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. Or it is possible to revert back to an automatic backup created automatically by FortiNAC in the backup folder. Log into the CLI on the Control Server with root privileges. Stop the FortiNAC processes: > shutdownNAC 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 Navigate to the /bsc/campusMgr/master_loader/mysql directory and restore the database.     For FortiNAC-F, navigate to /bsc/backups/database/ directory. > ydb_restore_full_backup <database_name> > FortiNAC-F : execute restore database local <database_name> Example: > ydb_restore_full_backup FortiNAC_DataBase_BackUp_2021_12_13_00_01_07_fnac88-std1.gz Start the FortiNAC processes: > startupNAC Related documents: FortiNAC Backup and Restore Version: 8.x FortiNAC-F backup and restore GUIDE  FortiNAC-F: Local Backup File Locations