39

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.?

Mr world wide
  • 3,879
  • 6
  • 34
  • 77

8 Answers8

103

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
Tejashwi Kalp Taru
  • 2,474
  • 2
  • 15
  • 26
7

Go to xampp/phpMyAdmin/libraries/config.default.php find $cfg['ExecTimeLimit'] = 300; line no 695 and replace $cfg['ExecTimeLimit'] = 0;

user1
  • 97
  • 6
7

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

Khem Raj Regmi
  • 1,454
  • 14
  • 16
6

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.

Saeed
  • 2,594
  • 2
  • 21
  • 36
Daminda Herath
  • 61
  • 2
2

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

chebaby
  • 5,564
  • 42
  • 40
1

in

config.inc.php

add this

$cfg['ExecTimeLimit'] = 0;

for me is work

Gibran Dimasagung
  • 11
  • 2
1

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
mohamed elshazly
  • 192
  • 5
1

MAC OS MAMP

edit this file

/Applications/MAMP/./bin/phpMyAdmin/config.inc.php

and dont forget restart MAMP

Ale DC
  • 577
  • 6
  • 11