Article ID: 116176, created on May 28, 2013, last review on May 11, 2014

  • Applies to:
  • Plesk


MySQL databases fail to migrate:

Failed to execute backup database
Manual backup done with migration agent reports errors in migration.result:
Timeout occured during mysql query. Reconnecting.
Unable to execute SQL: MySQL server has gone away


The problem may be caused by low wait_timeout parameter value in MySQL server configuration.


Increase wait_timeout on source and destination servers to the available maximum supported by version of MySQL server installed.

For Linux:

wait_timeout = 31536000

For Windows:

wait_timeout = 2147483

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF