Reputation: 64844

phpmyadmin: how to remove time limit to import big databases

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

Upvotes: 7

Answers (4)

Reputation: 2442

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;

Upvotes: 4

Reputation: 11080

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

Upvotes: 1

Reputation: 936

I use MySQL BigDump

Worked well for me yesterday!

Upvotes: 4

Reputation: 3290

Upvotes: 1