MySQL error: MySQL server has gone away
Recently I tried to import a huge database and I got an error saying:
[code]ERROR 2006 (HY000) at line 216: MySQL server has gone away[/code]
Solving this error is quick and easy and all you have to do is edit my.ini file from you MySQL installation directory.
Import Excel (XLS) document into MySQL database
The best way to read XLS files in PHP is using PHPExcelReader. It’s a great class becasue it does not use any COM objects, however the download package on SourceForge sometimes contains invalid XLS or example files, so I prepared a working package and you get get it here.
How to increase 2MB limit on import in phpMyAdmin?
PhpMyAdmin by default allows you to import only 2 MB file. In many cases this is just way too little.
In order to increase the values you need to alter your php.ini settings.
