Import large MySQL dump file in phpMyAdmin failed: 2006 - MySQL server has gone away

Created:

2016-11-16 13:20:38 UTC

Modified:

2017-04-24 11:38:40 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Import large MySQL dump file in phpMyAdmin failed: 2006 - MySQL server has gone away

Applicable to:

  • Plesk Onyx for Linux
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Windows

Symptoms

Attempt to import large MySQL dump file in phpMyAdmin failed with:

#2006 - MySQL server has gone away

Cause

Insufficient MySQL limits

Resolution

It is impossible to provide exact values as they depend on case. The following MySQL parameters should be increased in my.ini :

innodb_log_buffer_size
innodb_buffer_pool_size
net_read_timeout
net_write_timeout
max_allowed_packet
wait_timeout





For additional information please refer to MySQL Reference Manual

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