MySQL Forums
Forum List  »  Backup

ERROR 2006 (HY000): MySQL server has gone away
Posted by: David Ellenberger
Date: September 14, 2021 07:39AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
ERROR 2006 (HY000): MySQL server has gone away
403
September 14, 2021 07:39AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.