ERROR 2006 (HY000): MySQL server has gone away

[David Ellenberger]

Hello MySQL Admins!

I have a 88MB dump (typo3 website) that I want to load into my MySQL 5.7 database.

Unfortunately it fails with:
ERROR 2006 (HY000): MySQL server has gone away

I've tried a couple of things around the max_allowed_packet and wait_timeout, see my conf.d/custom.cnf below.

Does anyone know what else I could try now to finally load this dump?

Thanks much,

David



-

[mysqld]
skip-host-cache
skip-name-resolve
character-set-server=utf8
collation-server=utf8_unicode_ci
default_storage_engine=InnoDB
innodb_buffer_pool_instances=2
innodb_buffer_pool_size=3G
innodb_log_file_size=256M
innodb_log_buffer_size=4M
innodb_flush_log_at_trx_commit=2
innodb_thread_concurrency=8
key_buffer_size=16M
max_allowed_packet=128M
thread_stack=192K
thread_cache_size=32
query_cache_size=64M
table_open_cache=5000
table_definition_cache=800
sql_mode=NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
slow_query_log=1
slow_query_log_file=/var/log/mysql/mysql-slow.log
default_time_zone=Europe/Zurich
wait_timeout=300
interactive_timeout = 300

[mysql]
default-character-set=utf8
max_allowed_packet=128M

[client]
default-character-set=utf8
max_allowed_packet=128M

[mysqldump]
default-character-set=utf8
quick
quote-names
max_allowed_packet=128M
default_time_zone=Europe/Zurich

[mysqlimport]
default-character-set=utf8
default_time_zone=Europe/Zurich
max_allowed_packet=128M