Understanding and Maintaining Collected Data › How to Back Up and Restore CA Network Flow Analysis Data › Back Up the Main Databases Manually

Back Up the Main Databases Manually

You can back up data in either of the following ways:

• Add the database directories to your regular backup routine.
• Copy the files for the main databases manually, as described in this topic. This topic contains the steps for backing up data on a Windows server.

Follow these steps:

1. Open the Services window on the database installation server: Click Start, Control Panel, Administrative Tools, Services.

   Note: For a distributed configuration, the Enterprise Overview data and NFA console configuration data are on the NFA console server. The other databases that are discussed here are on the Harvester server. For a standalone system, all the databases are on the standalone server.

2. Stop the Custom Storage service and its dependent services:
   1. Right-click the NetQoS Mysql51 service in the Service window and click Stop.

      A confirmation message opens, which identifies the dependent services that will also stop.

   2. Click Yes.

      The confirmation message closes and the services stop.

   Note: On a Linux server that has a Harvester installed, stop the following services:

   • nfa_mysqlCSE
   • nfa_harvester
   • nfa_reaper
   • nfa_filewebservice
   • nfa_dataretention
3. Back up the database:
   • Console Data: To back up the NFA console configuration data and Enterprise Overview data, make a copy of the following directory (which is on the NFA console server or standalone server): <NFA_install_path>\MySql51\data\reporter.
   • Historical (15-Minute) Data: To back up the 15-minute data, make a copy of the following directory (which is located on the Harvester server or standalone server): <NFA_install_path>\Netflow\datafiles\ReaperArchive15.

     If you do not have enough space for all of the files, you can limit the backup to include only particular tables. Remember that the other collected data is not backed up, however.

   • High-Resolution (1-Minute) Data: To back up the 1-minute data, make a copy of the following directory (which is located on the Harvester server or standalone server): <NFA_install_path>\MySql51\data\archive.
   • Harvester Configuration Data: To back up the Harvester configuration data, make a copy of the following directory (which is located on the Harvester server or standalone server): <NFA_install_path>\MySql51\data\harvester.

   Note: The database paths are the same on Windows servers and Linux servers.

   To back up poller data, see Back Up the Poller Database.

4. Restart the NetQoS Mysql51 service and the dependent CA Network Flow Analysis services:
   1. Right-click the NetQoS Mysql51 service in the Services window and click Restart.
      The Restart Other Services confirmation message opens and lists all the dependent CA Network Flow Analysis services that will also restart.
   2. Click Yes.
   3. The confirmation message closes and the services stop and start again.

Back Up the Poller Database Manually

You can back up Poller data in either of the following ways:

• Add the directory to your regular backup routine.
• Copy the files manually, as described in this topic. This topic contains the steps for backing up data on a Windows server.

Poller data contains information about devices and interfaces, which is retrieved through polling.

Note: The database path is the same for a Windows server or Linux server.

Follow these steps:

1. Open the Services window on the standalone server or Harvester server: Click Start, Control Panel, Administrative Tools, Services.
2. Stop the CA NFA Poller service.

   Note: On a Linux server that has a Harvester installed, stop the following nfa_poller service.

3. Back up the database: Make a copy of the following directory (which is located on the Harvester or standalone server): <NFA_install_path>\MySql51\data\poller.
4. Restart the CA NFA Poller service (or the nfa_poller service on Linux).