Script timeout passed, if you want to finish import, please resubmit the same file and import will resume
PhpMysqlImportPhpmyadminIniPhp Problem Overview
I have a database
Un-zipped size 50mb zipped size 7mb
So when I try to import the database zipped(7mb) after few minutes it is throwing this error:
> Script timeout passed, if you want to finish import, please resubmit > the same file and import will resume.
I have resubmitted it but still not importing total data.
I am working in local and these are my php.ini configurations:
max_execution_time = 3000000
max_input_time = 60000000000000
memory_limit = 1280000000000000000000M
post_max_size = 4096456M
upload_max_filesize = 40964564M
max_file_uploads = 200
how can I let the system to take its own time for import.?
Php Solutions
Solution 1 - Php
If you are importing your database using Phpmyadmin, then there's a configuration file for it:
\phpmyadmin\libraries\config.default.php
Open this configuration file in any editor and change $cfg['ExecTimeLimit'] = 300; to $cfg['ExecTimeLimit'] = 0;
Restart your localhost, now you don't have any time limit.
Or you can use MySQL command line to import your unzipped SQL file directly, something like below:
mysql -u username -p database_name < my_unzipped_import_file.sql
Solution 2 - Php
Go to xampp/phpMyAdmin/libraries/config.default.php
find $cfg['ExecTimeLimit'] = 300; line no 695 and replace $cfg['ExecTimeLimit'] = 0;
Solution 3 - Php
Instead of XAMPP you may use LAMP(Linux Apache MySQL PHP) mostly. Using LAMP you may also face this problem.
In my case(using Ubuntu 15.10), I had configured/set post_max_size, upload_max_filesize, max_execution_time, max_input_time, memory_limit following my needs using php.ini file which is located at /etc/php5/apache2/php.ini
But still I was faced this problem. Then solved the problem using config.default.php file, where you can find out like this line below:
$cfg['ExecTimeLimit'] = 300; Make it to
$cfg['ExecTimeLimit'] = 0;
Note: You can locate config.default.php file via your terminal(Ctrl+Alt+T) by this commandlocate config.default.php possible path is /usr/share/phpmyadmin/libraries/config.default.php
Solution 4 - Php
Xampp in Ubuntu
If you are importing your database using PhpMyAdmin, then there's a configuration file for it:
> /opt/lampp/phpmyadmin/libraries/config.default.php
Open this configuration file in any editor and change $cfg['ExecTimeLimit'] = 300; to $cfg['ExecTimeLimit'] = 0;
Restart your localhost, now you don't have any time limit.
Solution 5 - Php
You need to change
$cfg['ExecTimeLimit'] = 300;
to
$cfg['ExecTimeLimit'] = 0;
in your config.php file located by default in \phpmyadmin\libraries\config.default.php
Restart your localhost.
It will definitely work. Enjoy.
Solution 6 - Php
WampServer Version 3 - Windows
Open config.default.php
You can find it here
C:\wamp\apps\phpmyadmin\libraries\config.default.php
Search for ExecTimeLimit
/**
* maximum execution time in seconds (0 for no limit)
*
* @global integer $cfg['ExecTimeLimit']
*/
$cfg['ExecTimeLimit'] = 300;
increase the value of $cfg['ExecTimeLimit'] or set it to 0 for no limit
Solution 7 - Php
in
config.inc.php
add this
$cfg['ExecTimeLimit'] = 0;
for me is work
Solution 8 - Php
MAC OS MAMP
edit this file
/Applications/MAMP/./bin/phpMyAdmin/config.inc.php
and dont forget restart MAMP
Solution 9 - Php
for lamp ubuntu :- first go to config.default.php location you can find by execute
locate config.default.php
in my case its locate at /usr/share/phpmyadmin/libraries
cd /usr/share/phpmyadmin/libraries
now edit config.default.php file in my case i use gedit you can install by
sudo apt install gedit
sudo gedit config.default.php
no search for ExecTimeLimit in file change $cfg['ExecTimeLimit'] = 300; to
$cfg['ExecTimeLimit'] = 0;
save and close it, restart server by
sudo service apache2 restart
Solution 10 - Php
This way will work with Windows OS + WAMP server
You can directly import .sql file via MySQL server by calling it from your CMD at this path C:\wamp64\bin\mysql\mysql{version}\bin
1- Open your CMD
2- cd C:\wamp64\bin\mysql\mysql{version}\bin
3- mysql -u root -p < {/path/to/your/sql/file/.sql}
This way didn't have a limitation on execution time compared to phpMyAdmin.