How do I export Application Definitions from one NFA Console and Import them Into Another?

Products

• Network Flow Analysis
• Network Observability

Issue/Introduction

How to export Application Definitions from one NFA Console and Import them Into Another via mysql.

Resolution

1. Backup the application definitions tables by opening a command prompt and running: 

(Starting in NFA 21.2.8, accessing the 'root' user in mysql now requires a password. By default, the root password is set to 'root@123'. If this password has been altered in your environment, enter the correct password in place of the default.)

mysqldump -uroot -proot@123 reporter application_mappings nbar2_application_definitions protocol_definitions protocol_domains port_definitions > appMaps.sql 

**Note do not use MS Powershell to perform mysqldump or to restore.

2. Copy the file over to the new server. 

3. Open a command prompt and run the following from the directory where you copied the file: 

mysql -uroot -proot@123 reporter < appMaps.sql 

4. Then login to mysql with: 

mysql -uroot -proot@123 reporter 

5. Run the following command: 

update system_settings set value=unix_timestamp() where parameter='applicationMappingLastModified'; 

6. Recycle the Netqos Reporter Manager Service which should import all of the rules and force the deployment of the rules to the Harvester.

7. Verify that new data reflects the application mappings which you imported.