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

Document ID : KB000072242
Last Modified Date : 22/05/2018
Show Technical Document Details
Introduction:
How to export Application Definitions from one NFA Console and Import them Into Another via mysql.
Instructions:
1. Backup the application definitions tables by opening a command prompt and running: 
mysqldump 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 reporter < appMaps.sql 

4. Then login to mysql with: 
mysql 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.