Change Script Timeout in phpMyAdmin September 11, 2008 > MySQL Tip

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;