There are two major issue with PHP, MySql and Apache combination when dealing with database dump or executing a SQL through phpMyAdmin - one that you are not allowed to upload a SQL file more than a specific limit and secondly, you keep getting following error again and again -

   1: MySQL Server has gone Away - Error 2006

I am working on Windows Vista and using phpMyAdmin as interface to MySQL.

To fix upload problem, you need to update upload_max_filesize variable inside php.ini file. By default, it is set to 2M (2 MB). I have changed it to 170M in order to accompany the files I am dealing with.

In order to keep MySQL functioning properly and not throwing errors like 2006 which comes up because of extremely large queries, set max_allowed_packet = 20M which is 1M by default. You can check value of variable by executing following command on MySQL prompt -

   1: show variables like ‘max_allowed_packet’;

In addition, to save your session timing out quickly, you can also consider changing max_execution_time variable in php.ini and LoginCookieValidity inside config.inc.php of phpMyAdmin.

There are more settings which can be referenced in order to keep all these things working properly. I am linking all the files with this post -

• httpd.conf
• my.ini
• php.ini
• config.inc.php

If you have installed or re-installed Apache server and you are facing error corresponding to port 80 specially when you think of yourself completely insane during installation, it is very possible that some other service is accessing Port 80. Following is the error message which appears while starting Apache as service or running httpd command from command prompt within Apache bin directory -

The Apache service named  reported the following error:
>>> (OS 10048)Only one usage of each socket address (protocol/network address/port) is normally permitted.  : make_sock: could not bind to address 0.0.0.0:80

In my case, I was running Skype which blocked port 80 and therefore, Apache wasn’t starting. Both Skype as well as Apache are justified in using same port as per its definition -

Typically, an HTTP client initiates a request by establishing a Transmission Control Protocol (TCP) connection to a particular port on a host (port 80 by default;

Apache Lounge (The Apache Webmasters & Programmers Community) is quite useful community to look out for resolution of most of your Apache related doubts, specially on Windows platform. The solution to above problem can be found at this thread. There is another useful thread which details about problems faced while re-installing Apache guiding about un-installation procedure and then installation of apache and PHP along-with their consolidation. I faced this problem after the consolidation, so came across this thread too.