Skip to main content
doncacciatoconsuting
Explorer II
January 6, 2025
Solved

Fortinac-F Upload database backup via WinSCP

  • January 6, 2025
  • 1 reply
  • 1458 views

The goal is to restore a saved database from my PC to a new Fortinac build running Forti-OS v7.2.8.

 

 

Following this article.

https://community.fortinet.com/t5/FortiNAC/Technical-Tip-Restore-FortiNAC-Database-from-CLI/ta-p/201729

 

 

Having two issues:

 

1- Using WinSCP, I connect to Fortinac, get authenticated, but it stalls out at "starting the session". Same result on multiple NAC appliances.

 

2- Looking at my directory structure in the linux shell, I do not even have this directory: "/bsc/campusMgr/master_loader/mysql/"

 

Any ideas ?

 

Best answer by ebilcari

This guide is based on older version of FNAC running in CentOS. In FNAC-OS, Winscp can no longer be used but FNAC can still transfer files using SCP, FTP and TFTP, some details can be found here.

For the database restore there is a direct command that can be used:

 

# execute restore database scp
Usage: execute restore database scp <host> <username> <password> <backup>
Restore database using a remote database backup downloaded via scp
<host> Remote host
<username> Remote username
<password> Remote password
<backup> Path to database backup on remote host (.gz)

 

Also FTP or TFTP can be used to first copy the old database in this path '/bsc/backups/database/' and than use the local restore command: # execute restore database local

1 reply

ebilcari
Staff
ebilcariAnswer
Staff
January 7, 2025

This guide is based on older version of FNAC running in CentOS. In FNAC-OS, Winscp can no longer be used but FNAC can still transfer files using SCP, FTP and TFTP, some details can be found here.

For the database restore there is a direct command that can be used:

 

# execute restore database scp
Usage: execute restore database scp <host> <username> <password> <backup>
Restore database using a remote database backup downloaded via scp
<host> Remote host
<username> Remote username
<password> Remote password
<backup> Path to database backup on remote host (.gz)

 

Also FTP or TFTP can be used to first copy the old database in this path '/bsc/backups/database/' and than use the local restore command: # execute restore database local

Emirjon
doncacciatoconsuting
Explorer II
January 7, 2025

thanks, that worked perfectly !