MySQL Server has gone away when importing large sql file

Before anything else, make sure you have set the upload_max_filesize value in your php.ini config file to allow importing large sql file.

If you need tutorial follow my previous post here.

Lets solve the error: #2006 MySQL Server has gone away when importing large sql file.

There are two common reasons caused either by the maximum allowed packet size ot InnoDB log file is too small.

In my case both of them, so we might need to resize the value, follow below:

1. If you still running your MySQL, shut it down.

2. Now edit my.conf in /etc/msql/my.conf (if you’re using xampp local server /mysql/bin/my.ini)

3. Find max_allowed_packet update value to 64MB

4. Find innodb_log_file_size update value to 256MB

5. Now Start MySQL

Note: If the error still show, repeat the instructions and increasing both values.

XAMPP Error Apache shutdown unexpectedly

Error: Apache shutdown unexpectedly.
This may be due to a blocked port, missing dependencies, improper privileges, a crash, or a shutdown by another method.

There are several reasons why your apache server is not working or unexpectedly shutdown. Main reason is some application is using port 80.

In my personal experience, it took me sometime hunting this application running on port 80 until i found a service called “Web Deployment Agent Service” (MsDepSvc) that also trigger “System” with PID4 to listen on port 80.

My apache server is now working properly after shutting down “Web Deployment Agent Service” (MsDepSvc) service.

Just want to share this great application called TCPView, this will show you detailed listings of all TCP and UDP endpoints on your system.

Hope that helps!