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: 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. 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.
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>
Start the FortiNAC processes:
startupNAC
 Related documents: | 
