max_allowed_packet and my.ini
Friday, February 1, 2008 | 
| |
(Apache, MySQL, PHP, Programming/Coding)
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 -
No Comments » | Spread the word: 