Return
-
Title
Database unable to backup -
Description
Unable to backup large database in MySQL server due to the error message listed below
ERROR MESSAGE
0 MYSQLIF ??? 15140 407 0 34119176602 Failed to execute query 'show variables like 'max\_allowed\_packet'': [2006][MySQL server has gone away]0 MYSQLBAC ??? 15140 633 0 34119176613 Failed to retrieve 'max_allowed_packet' from MySQL Server: 'Failed to execute query 'show variables like 'max\_allowed\_packet'': [2006][MySQL server has gone away]'0 MYSQLBAC ??? 15140 1005 0 34119177106 Cannot backup Stored Procedures for database 'sbmb'0 MYSQLBAC ??? 15140 810 0 34119175422 Ignore with Warnings table [ws_istilah] with action: [IGNORE+WARN]3 MYSQLIF ??? 15140 409 0 34119176565 Wildcards escaped in 'max_allowed_packet' to give 'max\_allowed\_packet'2 MYSQLBAC ??? 15140 908 0 34119177575 Function BackupDb() returned FALSE0 MYSQLBAC ??? 15140 678 0 34119177588 Failed to backup database 'sbmb'0 MYSQLBAC ??? 15140 1013 0 34119177596 Backup job failed, no data for backup. -
Cause
Table is big and time to backup takes many hours, the connection with MySQL Server might be dropped. Either because the connection timeout is reached, or for an external factor, including firewall, antivirus, etc.
-
Resolution
WORKAROUND:
None
STATUS:
Issue fixed in MySQL plugin version 12.2. Please upgrade to the latest MySQL plugin version.
-
Defect ID
DNMYSQL-406