The Mysqldump backup data (file *.sql) recovered in the NBU WebUI is truncated, but the job shows success.

Problem

The MySQL restore process includes two phases if the backup of the database is performed with the type mysqldump via NetBackup (NBU).

• Phase one: NBU restores <dumpfile.sql> to the location specified through the WEBUI or nbmysql;
• Phase two: Restores the MySQL database with <dumpfile.sql> through the MySQL command:
  • mysql -u <user name> -p <password> [target_database_name]  < <dumpfile.sql>

Running a restore job for the mysqldump backup is successful (Status code 0) in the NBU WebUI, but the contents of the file <dumpfile.sql> are truncated if the file size exceeds a certain size, such as  4GB. Phase two restore of the MySQL database with this overly large file <dumpfile.sql>  will fail with the message as described in the following error message section.

However, the same backup image can be restored through the command nbmysql and the database data can be recovered successfully with file <dumpfile.sql> in phase two .

Error Message

The following error occurs when the file <dumpfile.sql> recovered from the NBU WEBUI is used to restore the Mysql database through command :

mysql -u <user name> -p <password> [target_database_name]  < <dumpfile.sql>

ERROR 1064 (42000) at line 19721: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to 
use near ''ERROR MessagesConnection refused (Connection refused)java.net.ConnectException: C' at line 1 

There are no error messages related to the restore file <dumpfile.sql> job in the NBU TAR logs:
....
10:27:37.860 [14448.14448] <2> tcp_write: DBG - TCP - Sent (34) of (34) bytes on socket (2)
10:27:37.860 [14448.14448] <63> cRestoreTfi::finalSummary: DBG - INF -  TAR RESTORED 1 OF 1 FILES SUCCESSFULLY

Cause

The restored file is incomplete due to an incorrect bprd request which is sent from nbwmc service.

Solution

This issue is resolved in NetBackup 10.4 and higher releases.

If this issue is encountered on NetBackup 10.2 or 10.2.0.1, please contact Veritas Support to obtain the following EEBs:

• 10.2: 4132957
• 10.2.0.1: 4177223

Restart the NetBackup services after the EEB has been installed on the Primary server.