Database Backup Procedures › Take Additional Steps for Database Upgrade

Take Additional Steps for Database Upgrade

Important! The following procedure is only required if you are upgrading CA Performance Center Release 2.2.00 to Release 2.3.00.

Upgrades to CA Performance Center Release 2.3.00 involve a onetime upgrade to the database server to support more recent versions of Red Hat Enterprise Linux. Previous releases of CA Performance Center included MySQL v5.1, which must be upgraded to version 5.6.

The upgrade automatically backs up the database contents. However, if this step fails to execute properly, you must manually back up the CA Performance Center database and specify its use for an upgrade. An error message informs you whether the automatic backup has failed.

Follow these steps:

1. Back up the database by running the following command:

   echo 'show databases;' | mysql | grep -v ^Database$ | grep -v ^information_schema$ | grep -v ^mysql$ | grep -v ^test$ | grep -v performance_schema$ |  xargs mysqldump --add-drop-database --databases -R > databaseBackup.sql
   

   If mysqldump cannot be found, you can manually define the location of the backup file. For example, enter the following command:

   /opt/CA/MySql/bin/mysqldump
   

2. Create a file with filename responsefileName and contents that define the location of the backup file.

   The responsefileName file should contain the following contents:

   MYSQL_BACKUP_FILE=/tmp/databaseBackup.sql
   

3. Run the CA Performance Center installer with the response file option:

   ./tmp/CAPerformanceCenter.bin -f responsefileName
   

   The upgrade proceeds. The backup file that you created is used to populate the database.