Struggling with the error: Error: Maximum execution time of 300 seconds exceeded
Such a description of the error suddenly popped everyone can see who will try to upload a database to 10MB via phpmyadmin. This error is not related to the variable max_execution_time, located in php.ini and affecting the execution of scripts. Various instructions and guides to different offer to deal with this nasty bug: one is easier to edit php.ini, another httpd.conf. So, if you dump by pouring a large volume with phpmyadmin instead of the result get the error:
Fatal error: Maximum execution time of 300 seconds exceeded
The first thing that you need to find the configuration file and open it. Most often, it is saved under the name config.inc.php. It should be subjected to edit the following variable:
$ cfg ['ExecTimeLimit'] = 300;
In this case, you change the value of either 0 or a larger number (as in the example below).
$ cfg ['ExecTimeLimit'] = 3600;
A win-win way to resolve the error, for if something goes wrong, it will help the unlucky users free utility:
BigDump MySQL Importer.
Or you can cheat and having access to ssh, import the database dump quickly and painlessly:
gunzip <dbname.gz | mysql -u Username -p dbname
Just do not forget to first save the data in the format of gzip. This format compresses the necessary materials efficiently than usual zip.