#2006 MySQL Server has gone away error in Wamp

Error Description: Im using wamp / xamp server . When i try to import a sql file, either through MySQL Query Browser or PHPMyAdmin,i get the following error.

Error 2006: MySQL Server has gone away.
 

Solution:

You need to change max_allowed_packet, and the error will be fixed.
File Path: This configuration file is located at «XAMPP install directory, this is C:\XAMPP by default»\mysql\bin\my.ini.

# note the change has to be made at this section
[mysqld] 
port= 3306
socket= "/xampp/mysql/mysql.sock"
basedir="/xampp/mysql" 
tmpdir="/xampp/tmp" 
datadir="/xampp/mysql/data"
skip-locking
key_buffer = 16M
# it was 1M by default
max_allowed_packet = 2M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
 
 
  

Comments

Popular posts from this blog

GRANDING UTime Master - IDOR (CVE-2023-45393)

GRANDING UTime Master - Stored XSS (CVE-2023-45391)

Ericsson BSCS iX R18 Billing & Rating (ADMX, MX) - Stored XSS (CVE-2020-29144, CVE-2020-29145)