Restoring MySQL

Previous Next JavaScript must be enabled to correctly display this content

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 OCSM Server in the Backup Path provided in the MySQL Backup (From Version 4.4 & 5.0) or MySQL Backup (From Version 5.1)procedure.

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 OCSM Server:
```
mysqldump vsp blocks > blocks_dumps.sql
```
2. Copy this blocks_dumps.sql file to your existing MySQL backup directory.
Install the mysql-shell utility on the newly installed OCSM Server.
1. Go to the folder where MySQL RPMs are present. (MySQL 8 Commercial Package was downloaded from the Oracle software delivery during 5.1 OCSM rpm installation):
```
cd mysql-8.X/8.X.XX/
```
  For example:
```
cd /root/mysql-8.0/8.0.32/
```
2. Install the mysql shell rpm by running the following command:
```
yum install mysql-shell-commercial-X.X.XX-X.X.XXX.x86_64.rpm
```
  For example:
```
yum install mysql-shell-commercial-8.0.32-1.1.el8.x86_64.rpm
```
  Note:
  The mysql-shell rpm used here is based on the MySQL 8.0.32.
3. Copy the password from /root/.my.cnf and keep it handy.
  
  Figure 4-2 Copy Password