I had a problem while import database from my server to local around 117MB size. Suddenly i got in a problem. That was "Mysql has gone away". I surfed the net and got the solution.
When mysql server receives packet more than mentioned in max_allowed_packet in mysql server configuration, mysql server throw out the error "Mysql has gone away".
To fix this problem you can change max_allowed_packet value in my.cnf file in linux machine. This file will be in /etc/mysql/my.cnf
max_allowed_packet = 36M
Restart mysql.
Friday, September 19, 2008
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment