How to backup the CAPC database
search cancel

How to backup the CAPC database


Article ID: 48814


Updated On:


CA Application Delivery Analysis MTP (NetQoS / ADA) CA Infrastructure Performance CA eHealth



Steps on how to backup the CAPC database


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 


Release: PCSTAS99000-6.1-NetQoS-Performance Center-Stand-Alone-Server