This is how to prevent phpMyAdmin from timing out when importing an sql file.
I use XAMPP, and each time I was trying to import a large sql file, or a gzip file for that matter, phpMyAdmin threw a timeout error in my face.
After some investigation I came to this simple solution; In the file
config.inc.php which is in your phpMyAdmin's install dir, you put the snippet below:
/** * Set script timout in seconds * 0 = unlimited */ $cfg['ExecTimeLimit'] = 0; /* no script timeout */
Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp\phpMyAdmin\libraries\import\sql.php on line 129
Import has been successfully finished, 33211 queries executed.