Upgrade CA Executive Insight › Backup the CA Executive Insight Configurations and Database

Backup the CA Executive Insight Configurations and Database

To create the backup, copy the files in the installation directory to a backup directory. Then, export the database using the mysqldump utility, which is located in the mysql/bin directory. Once the files and database are backed up, you can then restore CA Executive Insight.

If the upgrade fails, this process creates back-up files that could be utilized to restore CA Executive Insight.

Follow these steps:

1. Stop CA Executive Insight.
2. Create a directory to contain the backed up CA Executive Insight configuration files.
3. Copy the config subdirectory within the directory where CA Executive Insight is installed into your newly created backup directory.

   The default installation location on Windows is C:\Program Files\CA\ExecutiveInsight.

   The default installation location on Linux is /opt/CA/ExecutiveInsight.

   You have successfully backed up the product configuration files.

   Note: If you are upgrading the mobile application user interface component for the internet accessible option, go to the next section.

4. Open the terminal/Command Prompt.
5. Point the terminal to the directory which has the MySQL binaries.

   For Windows, the default is:

   c:\Program files\MySQL\MySQL Server 5.5\bin
   

   For Linux, the default is:

   /usr/bin
   

6. To export your schema, enter the following commands and your MySQL passwords, when prompted:

   mysqldump -p -user=<username> -add-drop-table master > <backupdir>\masterbackup.bin
   

   mysqldump -p -user=<username> -add-drop-table tenant1 > <backupdir>\masterbackup.bin
   

   <username>

   Specifies the MySQL username of the user that is being used for CA Executive Insight schemas.

   Default: execdbadmin

   <backupdir>

   Specifies the directory where you want to store the backup files.

   If the MySQL programs are not in your path, manually specify the location of the mysqldump program in your commands.

   You have created a backup copy of CA Executive Insight.

Start the CA Executive Insight Upgrade

After you have backed up CA Executive Insight, run the installer to upgrade the server and mobile application UI. The installer automatically detects the previous version of the product and installs to the same default locations without prompting for the information again.

Note: The installation of the mobile application user interface does not prompt for any of the following steps.

MySQL Credentials

Specifies the credentials that are required to connect to the MySQL database. The user that is specified is the MySQL root user or a MySQL user with administrative privileges.

Supporting Components Location

Specifies the full path and name of the supporting components package file. The package file contains software components that are distributed under the GNU Lesser General Public License (LGPL). The name of the package files is as follows:

• On Windows:

  lgplPackages-win_1.1.zip
  

• On Linux:

  lgplPackages-linux_1.1.tar
  

Note: If you download the package file to the same location as the installation program, it validates the package file without prompting for it.

After a successful upgrade, validate that the application can be accessed and whether all data has been preserved.