ERROR 2006 (HY000) at line 526: MySQL server has gone away
July 27th, 2012 |
|
0 Comments »
Today I imported the MySQL database and I got the following error:
# mysql -u root -p db_test < test.db Enter password: ERROR 2006 (HY000) at line XX: MySQL server has gone away
It is because the data (SQL query) is too large to imported. To solve this problem, simply edit the MySQL configuration files: /etc/my.cnf
Replace the following from:
max_allowed_packet = 1M
To:
max_allowed_packet = 16M
Or something higher.
Restart the MySQL server again and the problem will be gone.
/etc/init.d/mysqld restart
Incoming search terms:
- error 2006 (hy000) at line mysql server has gone away centos (2)
- a database error occurred error number: 2006 mysql server has gone away (1)
- error 2006 (hy000) at line 1518: mysql server has gone away plesk (1)
- ERROR 2006 (HY000) at line 2: MySQL server has gone away debian (1)
- virtual box mysql server has gone away (1)
Comments (0)
Trackbacks - Pingbacks (0)