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.