Tech Tip: How to backup the 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

 

Change to a directory where you want to save the database archive, such as the following:

 

cd /tmp

 

Create a MySQL dump of the database using the following command:

 

/opt/CA/MySql51/bin/mysqldump netqosportal > netqosportal.sql

 

Note: During the installation, you are prompted to 'Select a Location for the MySQL Data Directory'. The default location is /opt/CA/MySql51/data.

 

Compress this backup to save space using the following command:

 

tar czvf netqosportal.tgz netqosportal.sql

 

Remove the uncompressed MySQL dump with this command:

 

rm netqosportal.sql

 

Start all of the CA Performance Center services using the following commands:

 

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


This document was generated from the following discussion: Tech Tip: How to backup the CAPC database

Attachments

    Outcomes