mysql gone away when import

March 24th, 2017 by Nov Piseth Leave a reply »

I was faced with this problem in my local and I’m using xampp. I was found out that┬ámax_allowed_packet original configuration for xampp is only 1MB. After I changed the setting and to 512M.

I work smoothly for import my database file *.sql to MySQL Server in local machine. It is very basic useful for me and also share to everyone.

please enjoy below basic configuration for general you can customize with your own.


[mysqld]
port= 3306
socket = "F:/xampp/mysql/mysql.sock"
basedir = "F:/xampp/mysql"
tmpdir = "F:/xampp/tmp"
datadir = "F:/xampp/mysql/data"
pid_file = "mysql.pid"
# enable-named-pipe
key_buffer = 16M
max_allowed_packet = 256M
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log_error = "mysql_error.log"
general_log = 1
general_log_file = 'F:\xampp\mysql\data\general_log.log'

Advertisement

Comments are closed.

Facebook Auto Publish Powered By : XYZScripts.com