phpmyadmin: how to remove time limit to import big databases

Question

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

I'm not able to upload a big database because of the limit and I have to login again in the database.

Thanks

Answer 1

I use MySQL BigDump

Worked well for me yesterday!

Answer 2

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

$cfg["ExecTimeLimit"]=36000;

adjusted the time limit will be 10 hours.

if you want to set an infinity time for timelimit you can use this

$cfg['ExecTimeLimit'] = 0;