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'
