Sfdwhf

Table formatting with tabularx?

3D Masyu - A Die

Found this skink in my tomato plant bucket. Is he trapped? Or could he leave if he wanted?

NIntegrate on a solution of a matrix ODE

Inverse square law not accurate for non-point masses?

Twin's vs. Twins'

Is it OK to use the testing sample to compare algorithms?

Improvising over quartal voicings

My mentor says to set image to Fine instead of RAW — how is this different from JPG?

Problem with display of presentation

How does the body cool itself in a stillsuit?

What is a more techy Technical Writer job title that isn't cutesy or confusing?

How do Java 8 default methods hеlp with lambdas?

Why is there so little support for joining EFTA in the British parliament?

Is there a spell that can create a permanent fire?

How do you cope with tons of web fonts when copying and pasting from web pages?

First paper to introduce the "principal-agent problem"

Why are current probes so expensive?

Why does BitLocker not use RSA?

How to make triangles with rounded sides and corners? (squircle with 3 sides)

What was the last profitable war?

Random body shuffle every night—can we still function?

How do I find my Spellcasting Ability for my D&D character?

Besides transaction validation, are there any other uses of the Script language in Bitcoin

In phpmyadmin, importing database shows timeout error in Ubuntu 15.10

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

0

I am getting an error "script timeout passed..." when trying to import a database.

I have already tried increasing various limits like max_size max_filesize max_time mem_limit in php.ini. But the problem remains.

Any help appreciated.

15.10 mysql phpmyadmin

share|improve this question

edited 50 mins ago

Zanna

51.5k13141244

asked Jun 3 '16 at 14:43

magento_psychomagento_psycho

313

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What have you changed max_execution_time to? Also, have you restarted php/apache after making the change?
  
  – user508889
  Jun 3 '16 at 14:44
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I have set 600 in max_execution_time. And yes, I have restarted apache after that change. @bc2946088
  
  – magento_psycho
  Jun 3 '16 at 15:21
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Just to be 100% sure the change has taken place, have you checked <?php phpinfo() ?> for those values?
  
  – user508889
  Jun 3 '16 at 15:23
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @bc2946088, Tnx much for your effort to help. Though I think i found the solution.
  
  – magento_psycho
  Jun 3 '16 at 15:27
  

  
  
  
  

add a comment | 

0

I am getting an error "script timeout passed..." when trying to import a database.

I have already tried increasing various limits like max_size max_filesize max_time mem_limit in php.ini. But the problem remains.

Any help appreciated.

15.10 mysql phpmyadmin

share|improve this question

edited 50 mins ago

Zanna

51.5k13141244

asked Jun 3 '16 at 14:43

magento_psychomagento_psycho

313

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What have you changed max_execution_time to? Also, have you restarted php/apache after making the change?
  
  – user508889
  Jun 3 '16 at 14:44
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I have set 600 in max_execution_time. And yes, I have restarted apache after that change. @bc2946088
  
  – magento_psycho
  Jun 3 '16 at 15:21
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Just to be 100% sure the change has taken place, have you checked <?php phpinfo() ?> for those values?
  
  – user508889
  Jun 3 '16 at 15:23
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @bc2946088, Tnx much for your effort to help. Though I think i found the solution.
  
  – magento_psycho
  Jun 3 '16 at 15:27
  

  
  
  
  

add a comment | 

I am getting an error "script timeout passed..." when trying to import a database.

I have already tried increasing various limits like max_size max_filesize max_time mem_limit in php.ini. But the problem remains.

Any help appreciated.

15.10 mysql phpmyadmin

share|improve this question

edited 50 mins ago

Zanna

51.5k13141244

asked Jun 3 '16 at 14:43

magento_psychomagento_psycho

313

share|improve this question

edited 50 mins ago

Zanna

51.5k13141244

asked Jun 3 '16 at 14:43

magento_psychomagento_psycho

313

share|improve this question

edited 50 mins ago

Zanna

51.5k13141244

asked Jun 3 '16 at 14:43

magento_psychomagento_psycho

313

edited 50 mins ago

Zanna

51.5k13141244

edited 50 mins ago

Zanna

51.5k13141244

asked Jun 3 '16 at 14:43

magento_psychomagento_psycho

313

asked Jun 3 '16 at 14:43

magento_psychomagento_psycho

313

2 Answers
2

active

oldest

votes

3

Pretty easy and simple step could be a solution:

Execution Time Limit needs to be set as 0 in config.default.php file. Which looks like $cfg['ExecTimeLimit'] = 300;

Make it to

$cfg['ExecTimeLimit'] = 0;

Location of that file supposed to be at /usr/share/phpmyadmin/libraries

Ref:Script timeout passed, if you want to finish import, please resubmit same file and import will resume

Hope this helps.

share|improve this answer

edited Apr 13 '17 at 12:25

Community♦

1

answered Jun 3 '16 at 15:16

perfectionist1perfectionist1

862

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yes, I got your ans correct. it helps. Thanks.
  
  – magento_psycho
  Jun 3 '16 at 15:28
  

  
  
  
  

add a comment | 

0

The accepted answer did not resolve this issue for me, but after some research I found a solution that did; in nginx server default config file after listen port #, add these lines:

fastcgi_read_timeout 3600; //ms to wait

fastcgi_send_timeout 3600;

share|improve this answer

edited 48 mins ago

Zanna

51.5k13141244

answered 3 hours ago

Serghei LeonencoSerghei Leonenco

1

New contributor

Serghei Leonenco is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f781385%2fin-phpmyadmin-importing-database-shows-timeout-error-in-ubuntu-15-10%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

3

Pretty easy and simple step could be a solution:

Execution Time Limit needs to be set as 0 in config.default.php file. Which looks like $cfg['ExecTimeLimit'] = 300;

Make it to

$cfg['ExecTimeLimit'] = 0;

Location of that file supposed to be at /usr/share/phpmyadmin/libraries

Ref:Script timeout passed, if you want to finish import, please resubmit same file and import will resume

Hope this helps.

share|improve this answer

edited Apr 13 '17 at 12:25

Community♦

1

answered Jun 3 '16 at 15:16

perfectionist1perfectionist1

862

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yes, I got your ans correct. it helps. Thanks.
  
  – magento_psycho
  Jun 3 '16 at 15:28
  

  
  
  
  

add a comment | 

3

Pretty easy and simple step could be a solution:

Execution Time Limit needs to be set as 0 in config.default.php file. Which looks like $cfg['ExecTimeLimit'] = 300;

Make it to

$cfg['ExecTimeLimit'] = 0;

Location of that file supposed to be at /usr/share/phpmyadmin/libraries

Ref:Script timeout passed, if you want to finish import, please resubmit same file and import will resume

Hope this helps.

share|improve this answer

edited Apr 13 '17 at 12:25

Community♦

1

answered Jun 3 '16 at 15:16

perfectionist1perfectionist1

862

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yes, I got your ans correct. it helps. Thanks.
  
  – magento_psycho
  Jun 3 '16 at 15:28
  

  
  
  
  

add a comment | 

Pretty easy and simple step could be a solution:

Execution Time Limit needs to be set as 0 in config.default.php file. Which looks like $cfg['ExecTimeLimit'] = 300;

Make it to

$cfg['ExecTimeLimit'] = 0;

Location of that file supposed to be at /usr/share/phpmyadmin/libraries

Ref:Script timeout passed, if you want to finish import, please resubmit same file and import will resume

Hope this helps.

share|improve this answer

edited Apr 13 '17 at 12:25

Community♦

1

answered Jun 3 '16 at 15:16

perfectionist1perfectionist1

862

$cfg['ExecTimeLimit'] = 0;

share|improve this answer

edited Apr 13 '17 at 12:25

Community♦

1

answered Jun 3 '16 at 15:16

perfectionist1perfectionist1

862

edited Apr 13 '17 at 12:25

Community♦

1

edited Apr 13 '17 at 12:25

Community♦

1

answered Jun 3 '16 at 15:16

perfectionist1perfectionist1

862

answered Jun 3 '16 at 15:16

perfectionist1perfectionist1

862

0

The accepted answer did not resolve this issue for me, but after some research I found a solution that did; in nginx server default config file after listen port #, add these lines:

fastcgi_read_timeout 3600; //ms to wait

fastcgi_send_timeout 3600;

share|improve this answer

edited 48 mins ago

Zanna

51.5k13141244

answered 3 hours ago

Serghei LeonencoSerghei Leonenco

1

New contributor

Serghei Leonenco is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

The accepted answer did not resolve this issue for me, but after some research I found a solution that did; in nginx server default config file after listen port #, add these lines:

fastcgi_read_timeout 3600; //ms to wait

fastcgi_send_timeout 3600;

share|improve this answer

edited 48 mins ago

Zanna

51.5k13141244

answered 3 hours ago

Serghei LeonencoSerghei Leonenco

1

New contributor

Serghei Leonenco is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

The accepted answer did not resolve this issue for me, but after some research I found a solution that did; in nginx server default config file after listen port #, add these lines:

fastcgi_read_timeout 3600; //ms to wait

fastcgi_send_timeout 3600;

share|improve this answer

edited 48 mins ago

Zanna

51.5k13141244

answered 3 hours ago

Serghei LeonencoSerghei Leonenco

1

New contributor

Serghei Leonenco is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

fastcgi_read_timeout 3600; //ms to wait

fastcgi_send_timeout 3600;

share|improve this answer

edited 48 mins ago

Zanna

51.5k13141244

answered 3 hours ago

Serghei LeonencoSerghei Leonenco

1

New contributor

Serghei Leonenco is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

edited 48 mins ago

Zanna

51.5k13141244

edited 48 mins ago

Zanna

51.5k13141244

answered 3 hours ago

Serghei LeonencoSerghei Leonenco

1

New contributor

Serghei Leonenco is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered 3 hours ago

Serghei LeonencoSerghei Leonenco

1