How to backup the CAPC database

Document ID : KB000048814
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Steps on how to backup the CAPC database

Solution:

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