PDA

View Full Version : Mysql_zrm-specific table restoration failed



Rajesh.G
February 11th, 2020, 07:35 AM
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 @ Zsupport@betsol.com.
Or call us @ 888-496-2632 (U.S.)/ 408-732-3208 (INTL)