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 –
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 –
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 –