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 OCSM Server. This downloads all the MySQL Backup files from Remote Server or Shared Drive on to your new OCSM Server.
    For the Remote Server, run the following scp command in the newly installed OCSM 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 OCSM 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 OCSM 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.