Fix “#2006 – MySQL server has gone away” Error in phpMyAdmin

I’m importing 3.5MB csv file into the database. After file uploading completed, the following error came out.

#2006 - MySQL server has gone away

It is because MySQL server drop if there is too large packet. To fix the error follow the steps below.

1. SSH to your VPS / Server

2. Edit my MySQL file. Remember to backup your /etc/my.cnf prior to that.

vi /etc/my.cnf

3. Add or edit max_allowed_packet in the MySQL configuration file

max_allowed_packet=16M

4. Save MySQL configuration file

5. Restart mySQL

service mysql restart

If the error still persist you may try to increase the value & try again.


Page 30 of 53« First...1020...2829303132...4050...Last »