CODEWITHSUNDEEP
mysqlsqldatabasephpmyadmin
RyckRichards
RyckRichards

Reputation: 29

How to import large sql files that would take more than 300s on phpMyAdmin?

I was trying to sql file - a big one (989MB) but I got this:

´Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp\phpMyAdmin\libraries\dbi\DBIMysqli.class.php on line 261´

I even read the line 261

return mysqli_query($link, $query, $method);

I read the documentation - https://dev.mysql.com/doc/search/?d=12&p=1&q=Fatal+error%3A+Maximum+execution+time+of+300+seconds+exceeded+in+C%3A%5Cxampp%5CphpMyAdmin%5Clibraries%5Cdbi%5CDBIMysqli.class.php+on+line+261 - but I wasn't able to find anything. That said, I'd need phpAdmin runs for 1 hour or even more

Is it possible to set that for infinite (no limit time)?

Edit - I got this > Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp\phpMyAdmin\libraries\import.lib.php on line 396. I had set to 10000 and unchecked "Allow the interruption of an import in case the script detects it is close to the PHP timeout limit. "

Upvotes: 0

Views: 1148

Answers (2)

peterulb
peterulb

Reputation: 2988

The setting is done in phpMyAdmin\libraries\config.default.php as

$cfg['ExecTimeLimit'] = 300;

That being said, this file should not be updated, use phpMyAdmin\config.inc.php

Upvotes: 1

gmc
gmc

Reputation: 3990

In phpMyAdmin's config file there is a variable $cfg['ExecTimeLimit'] that sets the maximum execution time (in seconds).

Upvotes: 1

Related Questions