How to fix “Script timeout passed”

In this article, we demonstrate how to address the “Script timeout passed, if you want to finish import, please resubmit the same file and import will resume” error encountered during the import of a 200MB database file into phpMyAdmin on an XAMPP localhost server.

What causes this issue?

When attempting to import a sizable database file into phpMyAdmin, the error arises due to predefined time limits for script execution (maximum execution time) in the database. With large databases, the execution time surpasses the limit, resulting in the “Script timeout passed” error. The default execution time limit on an XAMPP server is set to 300 seconds for each script, but for larger database files, the import process takes considerably longer than the default execution time allows.

Solutions

As you know if we are importing a large database file size through phpmyadmin then firstly you will make sure to update these limits. For increasing the limits Go to “C:\xampp\php\php.ini” and set the limits according to your need then saved it.

max_execution_time = 3000

max_input_time = 60000

memory_limit = 12800M

post_max_size = 4094M

upload_max_filesize = 4094M

max_file_uploads = 200

Now its time to increase the timeout limit 300s to infinity.

After updating the changes Go to C:\xampp\phpmyadmin\libraries\config.default.php and open into code editor And find “$cfg[‘ExecTimeLimit’] = 300;” it and make it value “$cfg[‘ExecTimeLimit’] = 0;” & save it.

$cfg['ExecTimeLimit'] = 300;  

update the value into 0

$cfg['ExecTimeLimit'] = 0;