Phpmyadmin: how to remove the time limit for importing large databases

Question

How can I remove the time limit for an import operation in phpmyadmin?

I cannot load a large database due to a limitation, and I need to log into the database again.

thank

Answer 1

I am using MySQL BigDump

Worked well for me yesterday!

Answer 2

you should not use phpmyadmin to load large databases ... use the mysql / mysqldump console.

but you can specify max_execution_time parameter in php.ini if ​​you really want

Answer 3

mysqldumper

Answer 4

you must open the config.inc.php file in the phpmyadmin root folder. add this line:

$cfg["ExecTimeLimit"]=36000;

The adjusted time interval is 10 hours.

if you want to set infinite time for timelimit you can use this

$cfg['ExecTimeLimit'] = 0;