PHPMyAdmin – Run Slow When Loading List of Databases


If you have lots of databases, especially if some of your database names share certain prefixes it could take quite long time for the database list to load. Add this to config.inc.php

$cfg[‘LeftFrameDBTree’] = false;

Now PHPMyAdmin display the list faster 🙂

Advertisements

Change Script Timeout in phpMyAdmin


Exporting mysql database to SQL format is our daily task. Sometime we get script timeout error when export process takes too long. This frequently happen when our internet connection too slow or the database size is too big. By default, phpMyAdmin set script execution timeout value to 300. You can change this value to any higher value you want, change it to 0 will tell phpMyAdmin to disable script timeout.

To change the value, do these steps:

1. Open file \phpmyadmin\libraries\config.default.php

2. Change the variable

$cfg[‘ExecTimeLimit’] = 300;

to

$cfg[‘ExecTimeLimit’] = 0;