Restoring MySQL

This section guides you with the procedure required for restoring the backup of Session Monitor's MySQL Data.

  1. Copy the MySQL Backup directory containing <DATABASE>.dump directory and blocks_replace.sql file from Remote Server or Shared Drive on to your new Session Monitor Server. This downloads all the MySQL Backup files from Remote Server or Shared Drive on to your new Session Monitor Server.
    For the Remote Server, run the following scp command in the newly installed Session Monitor Server:
    scp -r <User>@<Remote_Server_IP>:<path_to_MySQL_backup_directory>  <path_to_copy_backup>
    For example:
    scp -r root@10.184.19.114:/root/ocsmBackup/mysqlBackup/ /root/
    For Shared Drive, run the following cp command in the newly installed Session Monitor Server:
    cp -r <path_to_MySQL_backup_directory> <path_to_copy_backup>
    For example:
    cp -r /mnt/oracle/ocsmBackup/mysqlBackup/  /root/
    
  2. This step is required only if the node type is Mediation Engine .
    1. Take a mysql dump of blocks table of newly installed Session Monitor Server by running the following command.
      mysqldump vsp blocks > blocks_dumps.sql
    2. Copy this blocks_dumps.sql file to MySQL backup directory transferred in STEP 1.