Taking MySQL Dump of the Blocks Table

Take MySQL dump of blocks table. This step is required only if the node type is Mediation Engine.

  1. Move to the MySQL Backup directory (For example, cd /root/mysqlBackup/) and take a MySQL dump of the Blocks table. Run this command:
    mysqldump --skip-add-drop-table --skip-add-locks --no-create-info --replace vsp blocks > blocks_replace.sql
  2. Verify the blocks_replace.sql is created under the MySQL Backup directory. For example:
    [root@localhost ~]# ls -lrt /root/mysqlBackup/
    total 144
    drwxr-x---. 2 root root 143360 Mar 23 08:46 vsp.dump
    -rwxr-xr-x. 2 root root 143360 Mar 23 08:46 blocks_replace.sql

    Note:

    This step helps to fix any discrepancy caused by difference in the number of blocks between the Source Machine and the Target Machine.