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.