Back Up 9.0.1 Databases

Before you upgrade a CA Network Flow Analysis 9.0.1 deployment, back up the databases and files that are listed in the following table.

Database	Description	Standalone Server	Harvester Servers (Distributed)	NFA Console Server (Distributed)
reporter	Enterprise Overview data and NFA console configuration data	Important		Important
harvester	Harvester configuration data	Important	Important
nqrptr	Historical (15-minute) data	Recommended	Recommended
Customized Files	Configuration or other files that have been customized	Important	Important	Important
Windows Registry	Settings for the Harvesters		Important (Windows)

The following list describes the databases and their locations:

reporter database: Back up the previous 24 hours of Enterprise Overview data, NFA console configuration settings, and synchronization information.
Path: <install_path>\MySql51\data\reporter directory
harvester database: Back up the Harvester configuration data.
Path: <install_path>\MySql51\data\harvester directory
Nqrptr database: (Recommended) Back up the historical (15-minute) data that is stored for the reporting routers and interfaces.
Path: <install_path>\MySql51\data\nqrptr directory
Customized configuration files: Back up any customized configuration files--files that you customized or that were customized by CA Support. In addition, back up any customizations that you made to the website or reports.
The CA Network Flow Analysis configuration files typically have a .config, conf., or .ini extension and are located in the product installation path. Other customizations may include .css files and report logos.
Windows Registry: Back up the Windows Registry on Harvester servers. Harvester Registry settings are converted to MySQL database settings during the upgrade.
Back up the Registry as a .reg file by selecting File, Export in the Registry Editor window. For more information about the new location of Harvester settings, see the Release Notes topic "Relocation of Harvester Settings."

Important:

Make the backups run concurrently. If you restore data from backups that have different timestamps, problems can result. Ensure that your backed-up data files are timestamped with the same hour.
Store backups to a remote location to guard against the possibility of a hardware or OS failure on the main server. For example, back up the databases to an administrative share or mapped network drive.

Follow these steps:

Log in as a user who is a member of the Administrators group.
Connect to the server:
1. Open a Remote Desktop session.
2. Initiate a Terminal Services or VNC session to the installation server.
Copy each of the following directories or files to a remote location:
- Reporter database: Copy the following directory from the standalone server or the NFA console server of a distributed deployment: <install_path>\MySql51\data\reporter
- Nqrptr database: Copy the following directory from the standalone server or the DSA server of a distributed deployment: <install_path>\MySql51\data\nqrptr
- Customized configuration files: Back up any customized configuration files from the CA Network Flow Analysis installation path on any server. In addition, back up files that have been changed to customize reports, such as .css files and report logos.
Restart the services.