Error Code [87:19] Failed to import

A MySQL table-level restore operation of the sys database fails.

Symptoms

A MySQL table-level restore operation of the sys database fails with the following error:

Error Code: [87:19] Description: MySQL Database: [~sys~] Restore Failed with MySql Error: [~Failed to import. MYSQL Error -- ERROR 1305 (42000) at line 2173: FUNCTION sys.format_time does not exist mysqldump: Got errno 32 on write ~].

You can find the following errors in the MYSQLBLOCKRESTORE.log file:

44102 ac46 09/21 16:54:07 122510 MySqlBlockRetores::applyMySqlTblRst() - system failed cmd = [/usr/bin/mysqldump --defaults-file=/opt/commvault/Base/Temp/galaxy_bkp_mycnf_637_1537529000_44102_44102_122510.cnf -u root --flush-privileges --socket=/clone/mysql.sock --events --max_allowed_packet=4194304 --add-drop-database "sys" | /usr/bin/mysql --defaults-file=/opt/commvault/Base/Temp/galaxy_bkp_mycnf_637_1537528999_44102_44102_122510.cnf -u root --socket=/var/lib/mysql/mysql.sock -D "sys"]out = [] err = [ERROR 1305 (42000) at line 2173: FUNCTION sys.format_time does not exist mysqldump: Got errno 32 on write]

Causes

The --routines parameter is not a part of the mysqldump command.

Resolution

1. To the MySQL client, add the sAdvancedBackupOptions additional setting as shown in the following table:

| Property | Value | | --- | --- | | Name | sAdvancedBackupOptions | | Category | MySQL | | Type | String | | Value | --routines | 2. Run the restore operation again.