Linode Forum
Linode Community Forums
 FAQFAQ    SearchSearch    MembersMembers      Register Register 
 LoginLogin [ Anonymous ] 
Post new topic  Reply to topic
Author Message
PostPosted: Fri Nov 30, 2012 3:49 pm 
Offline
Senior Member

Joined: Thu Mar 11, 2010 1:09 pm
Posts: 62
I have large mysql database about 130 mb, I need to upload it through phpmyadmin, but I get error message

Script timeout passed

I already changed upload_max_filesize, memory_limit and post_max_size in php.ini and also Maximum execution time setting max_execution_time = 30000 but it looks like this is not working because after 5 or 10 minutes I get this script timeout error message. How could that be if I changed max_execution_time = 30000 which should be 500 minutes ?

And yes I restarted Apache after these changes :)

PS. I'm on local server, using xampp, but when I find out what is the problem, I will need to do all this on my Linode


Top
   
PostPosted: Fri Nov 30, 2012 5:12 pm 
Offline
Junior Member

Joined: Mon Oct 23, 2006 12:09 am
Posts: 26
It looks like PHPMyAdmin has its own config parameter for the timeout that overrides the PHP one.

See here: http://wiki.phpmyadmin.net/pma/Config#ExecTimeLimit

Have you tried changing that one?


Top
   
PostPosted: Sat Dec 01, 2012 6:49 am 
Offline
Senior Member

Joined: Thu Mar 11, 2010 1:09 pm
Posts: 62
Thank you very much :)


Top
   
PostPosted: Mon Dec 03, 2012 12:06 pm 
Offline
Senior Member
User avatar

Joined: Tue May 26, 2009 3:29 pm
Posts: 1691
Location: Montreal, QC
You should avoid doing large uploads like this via phpmyadmin, it can cause issues (such as this one). It's better to do it via the command prompt, using the mysql client.


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
RSS

Powered by phpBB® Forum Software © phpBB Group