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;
Very simple and exact what I want. Thanks.
This was driving me nuts… THANK YOU!
@ngkynam,
@GreG:
I’m glad you like the post 🙂
I’ve been at a similar problem for two days. In my case, I was importing, not exporting, a large(ish) database, but the problem was similar – a script timeout. Tried your fix, and was back up and running in minutes. Thanks!
Matt
I need script timeout unlimited in cakephp .Pls help me
Worked good, thanks for the quick and easy fix.
Shouldn’t you copy the $cfg[‘ExecTimeLimit’] = 300; to your config.inc.php rather than editing the config.default?
Thanks for posting this, but you should use config.inc.php instead
Thanks Dear No doubt this is nice trick which you are tell us other wise bigdump and other php script is so complex
damm! 🙂 thanks man
Thank u!
Really you should edit:
\phpmyadmin\config.inc.php
rather than:
\phpmyadmin\libraries\config.default.php
\phpmyadmin\config.inc.php does not contain exec.timelimit in the new phpmyadmin, I am not sure what version this changed in but worth the note. The change in\phpmyadmin\config.default.php should fix the timeout problem right up for you.
I would suggest for large databases to set the limit to 0 (no Limit) then change it back to a decent setting 600; gives you 10 minutes for most databases should be fine.
Thanks ! Just what I was looking for !
Thanks for the post.. this is new tick 4 me …
obrigado. I’m from Brazil.
Pingback: 如何在phpmyadmin中解决超时问题?|php问答
Pingback: [php] phpmyadmin에서 시간 초과를 해결하는 방법은 무엇입니까? - 리뷰나라
Pingback: How to solve time out in phpmyadmin?