In phpmyadmin, importing database shows timeout error in Ubuntu 15.10

Question

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.

What have you changed max_execution_time to? Also, have you restarted php/apache after making the change? — , Jun 03 '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 03 '16 at 15:21
Just to be 100% sure the change has taken place, have you checked <?php phpinfo() ?> for those values? — , Jun 03 '16 at 15:23
@bc2946088, Tnx much for your effort to help. Though I think i found the solution. — magento_psycho, Jun 03 '16 at 15:27

score 5 · Accepted Answer · edited Apr 13 '17 at 12:25

5

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.

edited Apr 13 '17 at 12:25

Community

1

answered Jun 03 '16 at 15:16

perfectionist1

236

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

score 0 · Answer 2 · edited Apr 22 '19 at 02:35

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;

edited Apr 22 '19 at 02:35

Zanna

70,465

answered Apr 22 '19 at 00:07

Serghei Leonenco

101

In phpmyadmin, importing database shows timeout error in Ubuntu 15.10

2 Answers2