Description

MySQL specific table restoration fails in ZRM. Single table restoration failed with below error.


Restoring from full backup /home/mysql-zrm/test2/20190103160301.
- sh: /opt/nbu-mysql/bin/nbu-mysql-parse-sql: No such file or directory
- }
- ERROR: Output of command: 'logical backup table restore' is {
- ERROR at line 1: Failed to open file '/tmp/zrmresttable-PJR5waGjdK', error: 2
- }
- ERROR: Restore from logical backup table failed
- ERROR: Restore failed
- ERROR: Restore failed


Solution:

Create a soft link to the original binary.

  • Login to MYSQL-ZRM server command line
  • Create the following directory

    #mkdir -p /opt/nbu-mysql/bin/

  • Create a soft link to the actual path

    #ln -s /usr/bin/mysql-zrm-parse-sql /opt/nbu-mysql/bin/nbu-mysql-parse-sql

  • Repeat restoration

************************************************** ************************************************** ******************
Please follow the above steps to fix the issue. In case if you need any assistance, kindly contact support.
support can be reached @ [email protected]
Or call us @ 888-496-2632 (U.S.)/ 408-732-3208 (INTL)