Restoring MySQL

This section provides instructions on the procedure required for restoring the backup of Session Monitor's MySQL Data.

MySQL backup will be present in your new Session Monitor Server in the Backup Path provided in the MySQL Backup procedure.
  1. This step is required only if the node type is Mediation Engine
    1. Run this command to take a MySQL dump of the blocks table of the newly installed Session Monitor Server:
      mysqldump vsp blocks > blocks_dumps.sql
    2. Copy this blocks_dumps.sql file to your existing MySQL backup directory.
  2. Install the mysql-shell utility on the newly installed Install the mysql-shell utility on the newly installed Session Monitor server.
    1. Go to the folder where you extracted the OCSM Zip bundle (ocsm-5.2.0.0.5-GA.zip) during the installation of Session Monitor.

      Note:

      The MySQL 8.0.41 shell utility rpm is packed as part of the OCSM Zip bundle under other_files/mysql-shell-commercial-8.0.41-1.1.el8.x86_64.rpm
    2. Move to the other_files directory: cd other_files/
    3. Install the MySQL shell RPM by running the following command: yum install mysql-shell-commercial-X.X.XX-X.X.XXX.x86_64.rpm
      yum install mysql-shell-commercial-8.0.41-1.1.el8.x86_64.rpm

      Note:

      The mysql-shell rpm used here is based on the MySQL 8.0.41 used inSession Monitor Release 5.2
    4. Copy the password from /root/.my.cnf and keep it handy.

      Figure 4-2 Copy Password


      Copy Password