How do I backup a single table from an NFA mysql database?
book
Article ID: 186167
calendar_today
Updated On:
Products
CA Network Flow Analysis (NetQos / NFA)
Issue/Introduction
How do I backup a single table from an NFA mysql database?
Environment
Release : 10.0
Component : NQRPTA - REPORTERANALYZER
Resolution
You can use mysqldump in a regular cmd prompt (not powershell) to backup a single table or multiple tables using the syntax below:
mysqldump (database name) (table names separated by spaces) > fileName.sql
The file will be created in the directory you ran it.
For example to backup the reporter.system_settings table on the NFA console you could run:
mysqldump reporter system_settings > system_settings_reporter.sql
Or to backup multiple table, for example your application mapping definitions you could run:
mysqldump reporter protocol_definitions protocol_domain application_mappings > apps.sql
Before restoring any individual table, please contact support to understand the impact and proper procedure.
Feedback
thumb_up
Yes
thumb_down
No