MySQL thoughts

Helpful tips for MySQL

MySQL server has gone away

If during the import data to MySQL from external source (like net) you are victim of:

MySQL server has gone away

Try to adjust values of following parameters in your my.cnf file:

max_allowed_packet = 1024M
wait_timeout = 1800
net_read_timeout= 1800

And restart server to adapt the changes.