Web Hosting Talk







View Full Version : MySQL Error 2006: MySQL server has gone away


MaB
12-29-2002, 01:54 PM
When trying to import a .sql file for a customer (its 200,000 lines) i get:

ERROR 2006 at line 4393: MySQL server has gone away


Mabey, is there some type of limit to how many entries you can add in a certain amount of time?


Thanks

xerophyte
12-29-2002, 02:50 PM
Hi
You need to increase the max packet size that mysql can handle... try
putting this in your my.cnf file under [mysqld]:

set-variable = max_allowed_packet=5M

and restarting your server (obv. if you're starting mysql from the command
line use the switch --max_allowed_packet)

MaB
12-29-2002, 03:01 PM
Thank you very much :)