Skip to main content
FortiKoala
Staff
Staff
September 28, 2018

Technical Tip: Loading an older database via CLI

Description

 

This article describes that if a database corruption has occurred, it may be necessary to restore an older database.

Note: 
  • Any hosts registered since the date and time of the older database will become rogue again once the database is restored. 
  • Any devices added to Topology since the older database time will also be removed.

 

Scope

 

FortiNAC.


Solution

 

  1. SSH to the Control Server and log in with root credentials.

  2. Navigate to the backup directory and shut down the control processes.

cd  /bsc/campusMgr/master_loader/mysql/backup/
shutdownNAC
 
  1. Load the desired database.

../ydb_restore_full_backup  <filename>
 
Example:  
 
../ydb_restore_full_backup NetworkSentry_DataBase_BackUp_2017_05_29_01_01_2
 
The command prompt will return once the database is loaded.
 
  1. Start Network Sentry processes.
     
    startupNAC
Related article:

Technical Note: Loading an older database via administrative UI

Thought Leadership. Security Summit. Thursday, November 12th, PGA National Resort, Palm Beach Gardens, FL.
Thought Leadership. Security Summit. Thursday, October 8th. Disney's Grand Californian Hotel & SPA, Anaheim, CA.
Security Operations Summit: Modernize SecOps. Operate AI-Native.AMER: November 4 | 9:00 AM PST. India and SAARC: November 5 | 10:00 AM IST. EMEA: November 5 | 10:30 AM CET. APAC: November 5 | 11:00 AM SGT