The Phoca Changing collation tool changes the database collation of database, tables and columns.
Archive for October, 2010
28 Oct
Fatal error: Maximum execution time of 300 seconds exceeded PhpMyAdmin Xampp
ERROR MESSAGE:
Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampplite\phpMyAdmin\libraries\dbi\mysqli.dbi.lib.php on line 176
Look for this line and adjust as required:
$cfg['ExecTimeLimit'] = 300; // maximum execution time in seconds (0 for no limit)
If your config-inc.php file is small and missing the above line or missing altogether then the file config.default.php in the .\xampp\phpMyAdmin\libraries folder is used.
/**
* maximum execution time in seconds (0 for no limit)
*
* @global integer $cfg['ExecTimeLimit']
*/
$cfg['ExecTimeLimit'] = 300;
Copy this file in to the phpMyAdmin main folder and rename it config-inc.php or copy the contents into the existing config-inc.php file and then do your editing in this new file not in the config-default.php file – this procedure makes it easier, as now all phpMyAdmin configs will be in the one place not in 2 locations with one being editable (config-inc.php) and the other not editable (config-default.php).
written by Sharley
