Ttgjyuk

The test team as an enemy of development? And how can this be avoided?

Why does BitLocker not use RSA?

How does the body cool itself in a stillsuit?

Did pre-Columbian Americans know the spherical shape of the Earth?

Sally's older brother

malloc in main() or malloc in another function: allocating memory for a struct and its members

Why not use the yoke to control yaw, as well as pitch and roll?

Is there a spell that can create a permanent fire?

An isoperimetric-type inequality inside a cube

By what mechanism was the 2017 UK General Election called?

Was the pager message from Nick Fury to Captain Marvel unnecessary?

How to ask rejected full-time candidates to apply to teach individual courses?

How to make an animal which can only breed for a certain number of generations?

First paper to introduce the "principal-agent problem"

Random body shuffle every night—can we still function?

Derived column in a data extension

In musical terms, what properties are varied by the human voice to produce different words / syllables?

Can two people see the same photon?

Why are two-digit numbers in Jonathan Swift's "Gulliver's Travels" (1726) written in "German style"?

How to resize main filesystem

"Destructive power" carried by a B-52?

What are some likely causes to domain member PC losing contact to domain controller?

Where did Ptolemy compare the Earth to the distance of fixed stars?

Why do C and C++ allow the expression (int) + 4*5;

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 facing a problem to import a database.

It shows "Script timout passed.... ". While I have already been enlarge all digits like max_size max_filesize max_time mem_limit in php.ini. But the problem exists.

Any help appreciated.

15.10 mysql phpmyadmin

share|improve this question

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 facing a problem to import a database.

It shows "Script timout passed.... ". While I have already been enlarge all digits like max_size max_filesize max_time mem_limit in php.ini. But the problem exists.

Any help appreciated.

15.10 mysql phpmyadmin

share|improve this question

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 facing a problem to import a database.

It shows "Script timout passed.... ". While I have already been enlarge all digits like max_size max_filesize max_time mem_limit in php.ini. But the problem exists.

Any help appreciated.

15.10 mysql phpmyadmin

share|improve this question

asked Jun 3 '16 at 14:43

magento_psychomagento_psycho

313

share|improve this question

asked Jun 3 '16 at 14:43

magento_psychomagento_psycho

313

share|improve this question

asked Jun 3 '16 at 14:43

magento_psychomagento_psycho

313

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 Answer did not resolved my issue, but after some research i did found a solution, to add in server nginx default config file after listen port #, this lines:

fastcgi_read_timeout 3600; //ms to wait
fastcgi_send_timeout 3600;

share|improve this answer

answered 18 mins 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 Answer did not resolved my issue, but after some research i did found a solution, to add in server nginx default config file after listen port #, this lines:

fastcgi_read_timeout 3600; //ms to wait
fastcgi_send_timeout 3600;

share|improve this answer

answered 18 mins 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 Answer did not resolved my issue, but after some research i did found a solution, to add in server nginx default config file after listen port #, this lines:

fastcgi_read_timeout 3600; //ms to wait
fastcgi_send_timeout 3600;

share|improve this answer

answered 18 mins 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 Answer did not resolved my issue, but after some research i did found a solution, to add in server nginx default config file after listen port #, this lines:

fastcgi_read_timeout 3600; //ms to wait
fastcgi_send_timeout 3600;

share|improve this answer

answered 18 mins 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

answered 18 mins 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 18 mins 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 18 mins ago

Serghei LeonencoSerghei Leonenco

1