Tech Tip: How to restore a backed up CAPC database

Document created by PearC Employee on Aug 8, 2014Last modified by SamCreek on Dec 17, 2016
Version 2Show Document
  • View in full screen mode

Log in to the server as root, or use the sudo account you configured for the installation.

 

Stop all of the CA Performance Center services, using the following commands:

 

/etc/init.d/caperfcenter_eventmanager stop
/etc/init.d/caperfcenter_devicemanager stop
/etc/init.d/caperfcenter_sso stop
/etc/init.d/caperfcenter_console stop

 

The services are stopped.

 

Change to the directory where you saved the backup archive. For example:

 

cd /tmp

 

Uncompress the database backup archive by executing the following command:

 

tar zxvf netqosportal.tgz

 

Import the uncompressed backup file:

 

/opt/CA/MySql/bin/mysql netqosportal -e ‘source netqosportal.sql’

 

Start all of the CA Performance Center services:

 

/etc/init.d/caperfcenter_eventmanager start
/etc/init.d/caperfcenter_devicemanager start
/etc/init.d/caperfcenter_sso start
/etc/init.d/caperfcenter_console start

 

Delete the uncompressed archive file to save space:

 

rm netqosportal.sql

 

Log in to CA Performance Center as an administrator.

 

Verify that your configuration data appears in Admin pages.


This document was generated from the following discussion: Tech Tip: How to restore a backed up CAPC database

Attachments

    Outcomes