Script timeout has passed, if you want to complete the import, resubmit the same file and the import will resume

I have a database Size without gaps 50mbzipper size 7mb Therefore, when I try to import a zipped database (7 MB) after a few minutes, it throws this error:

Script timeout, if you want to complete the import, please resend the same file and the import will be resumed.

I re-submitted it, but did not import the totals.

I work locally 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 take its time to import.?

+18
6

Phpmyadmin, :

\phpmyadmin\libraries\config.default.php

$cfg['ExecTimeLimit'] = 300; $cfg['ExecTimeLimit'] = 0;

, .

MySQL, SQL , - :

mysql -u username -p database_name < my_unzipped_import_file.sql
+41

XAMPP LAMP (Linux Apache MySQL PHP) . LAMP, .

( Ubuntu 15.10) / post_max_size, upload_max_filesize, max_execution_time, max_input_time, memory_limit , php.ini, /etc/php5/apache2/php.ini.

. config.default.php, :

$ cfg ['ExecTimeLimit'] = 300;

$ cfg ['ExecTimeLimit'] = 0;

: config.default.php (Ctrl + Alt + T) locate config.default.php. : /usr/share/phpmyadmin/libraries/config.default.php

+4

xampp/phpMyAdmin/libraries/config.default.php $cfg['ExecTimeLimit'] = 300; № 695 $cfg['ExecTimeLimit'] = 0;

+3

Xampp Ubuntu

PhpMyAdmin, :

/opt/lampp/phpmyadmin/librariesconfig.default.php

$cfg ['ExecTimeLimit'] = 300; $cfg ['ExecTimeLimit'] = 0;

, .

+2

WampServer 3 - Windows

config.default.php

C:\wamp\apps\phpmyadmin\libraries\config.default.php

ExecTimeLimit

/**
 * maximum execution time in seconds (0 for no limit)
 *
 * @global integer $cfg['ExecTimeLimit']
 */
$cfg['ExecTimeLimit'] = 300;

$ cfg ['ExecTimeLimit'] 0

+1

config.inc.php

$cfg['ExecTimeLimit'] = 0;

0

Source: https://habr.com/ru/post/1685522/


All Articles