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