Trying to import database: MySQL server has gone away

Asked Sep 28 '17 at 21:48

Active Sep 28 '17 at 22:11

Viewed 41 times

Running this command:

mysql -u root -p dev_db < dev.sql

Error:

ERROR 2006 (HY000) at line 454: MySQL server has gone away

I already added this line to /etc/my.cnf (which most other answers on StackOverflow suggest):

max_allowed_packet=32M
wait_timeout = 600

edited Sep 28 '17 at 22:11

asked Sep 28 '17 at 21:48

User

The duplicate question this is linked to is not the correct solution. The answer was actually here: https://stackoverflow.com/questions/13717277/how-can-i-import-a-large-14-gb-mysql-dump-file-into-a-new-mysql-database – User Sep 29 '17 at 03:27
How long does it run before timing out? – Rick James Sep 29 '17 at 05:31
@RickJames maybe 45 seconds – User Sep 29 '17 at 05:45
`innodb_lock_wait_timeout` defaults to 50 sec; I wonder if it could be relevant. – Rick James Sep 29 '17 at 05:49

0 Answers0