ERROR 2006 (HY000) at line XXX: MySQL server has gone away
SOLUTION:
- Stop mysql-server
# /usr/local/etc/rc.d/mysql-server stop - Open file my.cnf in mysql directory
- Add this 2 line:
[mysqldump]
quick max_allowed_packet = 16M
[mysqld]
max_allowed_packet=32M
[mysql]
max_allowed_packet=32M - Start mysql-server back
# /usr/local/etc/rc.d/mysql-server start - Try restore the mysql db again
# mysql -uroot -p --default-character-set=utf8 < filenamexxxx.sql
**It works for me. Try it yourself.
.
0 comments:
Post a Comment