phpmyadmin: how to remove time limit to import big

问题:

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

回答1:

I use MySQL BigDump

Worked well for me yesterday!

回答2:

you shouldn't use phpmyadmin to upload big databases... use console mysql/mysqldump.

but you can chenge max_execution_time parameter in your php.ini if you really want to

回答3:

Try out mysqldumper

回答4:

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;