phpMyAdmin: Script timeout passed, if you want to finish import, please resubmit same file and import will resume. (Solved)

Open the file  xampp\php\php.ini

Find:
post_max_size
upload_max_filesize
max_execution_time
max_input_time
memory_limit

Change to:
post_max_size = 500M
upload_max_filesize = 500M
max_execution_time = 300
max_input_time = 500
memory_limit = 1000M

Reboot MySQL and Apache, on the “import” window, it may not show 500M in the Maximum place, I can’t remember clearly. But when I re-import the file, it still shows “Script timeout passed, if you want to finish import, please resubmit same file and import will resume.”

Then I go to xampp\phpMyAdmin\config.inc.php, add this line
$cfg[‘ExecTimeLimit’] = 0;

It’s said it can make the limit to infinity.

Then I reboot MySQL and Apache and re-import, it shows “MySQL has gone away”, I increase the limit in the configuration file of MySQL, finial I succeed.

Leave a Reply

Your email address will not be published. Required fields are marked *