3

I try to import the excel showing error message.how to set max_allowed_packet in XAMPP. kindly share folders name and file name.

Karthick Kumar
  • 77
  • 1
  • 12
  • I'm trying to import a Excel CSV file into my database.but it failed and shows "#2006 - MySQL server has gone away" – Karthick Kumar Feb 24 '15 at 04:02
  • 1
    possible duplicate of [MySQL error 2006: mysql server has gone away](http://stackoverflow.com/questions/7942154/mysql-error-2006-mysql-server-has-gone-away) – Thilo Feb 24 '15 at 04:05
  • how to change set max_allowed_packet in xampp..? send file path also.. – Karthick Kumar Feb 24 '15 at 04:08

1 Answers1

4

Change the value on this file C:/xampp/mysql/bin/my.cnf using notepad or any other text editor. Increase max_allowed_packet as needed

your file might look like this,

enter image description here

Restart mysql service

enter image description here

Leandro Papasidero
  • 3,728
  • 1
  • 18
  • 33