Importing sqldump into docker-container

Question

I am trying to import a sqldump into a running MySQL Docker-Container with this command:

 sudo docker exec -i a2bdd4db352a /usr/bin/mysql -u username -ppassword --max_allowed_packet=1500M --default-character-set=utf8 database < /srv/Dump.sql

After a while getting these error:

ERROR 2006 (HY000) at line 979: MySQL server has gone away
read unix @->/var/run/docker.sock: read: connection reset by peer

Logs:

2017-12-07T09:44:21.099302Z 3 [Note] Aborted connection 3 to db: 'database' user: 'database' host: 'localhost' (Got a packet bigger than 'max_allowed_packet' bytes)

Tried to increase the max_allowed_package variable in my MySQL-Conf ---> Nothing changed - still the same error.

My Dump has a size of 16 GB.

Has anybody a idea - how to fix this?

sanath meti · Accepted Answer · 2017-12-07 13:50:42Z

1

Error says the particular row data has size more than 1500M, so try increasing max_allowed_packet to higher value

For detailed info refer below link http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_max_allowed_packet

answered Dec 7, 2017 at 13:50

sanath meti

6,8011 gold badge27 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

adbo Over a year ago

Thanks for your answer. The Problem was that i had increased this value but forget to comment in the special line for using my configuration in Dockerfile.

Muh faris · Accepted Answer · 2017-12-07 12:51:44Z

0

Do you have tried to increase the paramater --max_allowed_packet=1500M to --max_allowed_packet=200000M ?

answered Dec 7, 2017 at 12:51

Muh faris

1962 silver badges7 bronze badges

Collectives™ on Stack Overflow

Importing sqldump into docker-container

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related