Timeout importing mysql backup?

**Matt Seigneur** · 25-09-09

I'm trying to import a backup of mysql into phpmyadmin and the file is about 1.7MB, I'm getting this error message

Code:

Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/import/sql.php on line 124

Anyone know how to increase the time before it times out?

Cheers!
Matt

**Sproates** · 25-09-09

You can set $cfg['ExecTimeLimit'] in config.inc.php to zero which should mean it will never time out.

PHP Code:


$cfg['ExecTimeLimit']  = 0;

**Matt Seigneur** · 25-09-09

Thanks for the quick reply, Where would i find that?

**ian** · 25-09-09

you should be able to do it in ssh

ssh mysql import - Google Search

**Sproates** · 25-09-09

Originally Posted by Matt Seigneur

Thanks for the quick reply, Where would i find that?

In the config.inc.php file, which is in the directory where phpmyadmin lives.

**Matt Seigneur** · 25-09-09

That's great thanks v much! :tup

Affiliates4u – The Hub of Affiliate and Performance Marketing