Database Backup Procedures › Create a Backup Archive

Create a Backup Archive

Create a backup archive of the current CA Performance Center database anytime you plan to reinstall or upgrade the software. It is also a recommended best practice to create a backup archive on a weekly basis.

Follow these steps:

1. Log in to the server as root, or use the sudo account you configured for the installation.
2. 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
   

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

   cd /$backupDir
   

   Use any secure location for the backup directory.

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

   /opt/CA/MySql/bin/mysqldump netqosportal > $backupDir/netqosportal.sql
   

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

5. Create a MySQL dump of Event Manager data:

   /opt/CA/MySql/bin/mysqldump em > $backupDir/em.sql
   

6. Compress these backup files to save space using the following commands:

   tar czvf netqosportal.tgz netqosportal.sql
   tar czvf em.tgz em.sql
   

7. Remove the uncompressed MySQL dump files using the following commands:

   rm netqosportal.sql
   rm em.sql
   

8. 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