MySQL migration failed: Not all content may be restored

Created:

2016-11-16 13:08:17 UTC

Modified:

2017-08-16 16:31:46 UTC

0

Was this article helpful?


Have more questions?

Submit a request

MySQL migration failed: Not all content may be restored

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 11.x for Windows
  • Plesk 12.0 for Windows
  • Plesk 12.0 for Linux

Symptoms

The following error appears during database transfer while performing migration to Plesk:

Warning: domain "DOMAIN_NAME"
Failed deployment of database DB_NAME (domain DOMAIN_NAME)
Warning:
Errors occurred during deployment of database content. Not all content may be restored. Resolve the errors if required or try to restore the content manually from the archive: [sqldump]: ..\\DOMAIN_NAME\\databases\\DB_NAME.zip
Warning:
Execution of "C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\bin\\/mysql" --no-defaults -u DB_USER_NAME -h localhost -P 3306 DB_NAME failed with return code 1.
Stdin is
source C:\\Program Files (x86)\\Parallels\\Plesk\\PrivateTemp/migration-unpack-01cf7be387b28510/DB_NAME.sql
exit
Stderr is
ERROR 2006 (HY000) at line 1940 in file: 'C:\\Program Files (x86)\\Parallels\\Plesk\\PrivateTemp\\migration-unpack-01cf7be387b28510\\DB_NAME.sql': MySQL server has gone away

Cause

The limit of maximum allowed request packet size has exсeeded.

Resolution

Add the following string to %plesk_dir%\Databases\MySQL\data\my.ini file:

max_allowed_packet=50M

Restart MySQL server and migrate the domain again.

Try to increase this limit up to 1Gb, if the error is not gone.

Have more questions? Submit a request
Please sign in to leave a comment.